i think it's related to permissions; a lot of the time someone might get a permissions error that says

"User does not have required permissions. Verify that sufficient permissions have...

is there a specific error? what if you try https?

old thread from six years ago...

the msdb object mentioned msdb.dbo.restorehistory is not a system object; adding a trigger to...

since this is on a cluster, pretty sure you cannot use local disks to each box, regardless of whether they are SSD's or not ; only drives that are shared...

is it accessing metadata, like sys.tables and stuff,so you KNOW the object sit access exist in ALL databases, or is it assuming that specific tables exist int he database you...

the public role has access to tempdb, so you could create a semi-permanent table that would exist until the sql service was stopped and started/server rebooted, by creating...

not sure if this is what you are after, this was my first guess

/*--Results

ClosestUnder ClosestOver

20 25

*/

;WITH MyCTE([Code],[Number],[Value])

AS

(

SELECT '5',convert(float,'10.00'),convert(money,'1.9201') UNION ALL

SELECT...

did you try the query at all?

i just made a minor change and tested, i got this error because the directory structure is not there yet, could that be it?

Msg 50000, Level 16, State 1, Procedure...

yeah, i think my sum case will do exactly that for you.

what does this return? does it look right?

SELECT

USERNAME as [User Name],

SUM(CASE WHEN [Status_Type] =...

if you look at it the other way, are the last eight characters of the file name always a correctly formatted datestring?

so it-doesn-t-matter-about-dashes04122016.txt? can get me the right values with...

I'm thinking you'll need to group by your username, and maybe some other columns, and use the SUM(CASE trick to count the items meeting your criteria.

my first guess , based...

prachiverma10 (4/12/2016)

---

@Lowell, Thank you so much for your help. I did miss to end the if statement.

Regarding the other issue you pointed out, can you give an example in what...

prachiverma10 (4/11/2016)

---

I have created a trigger, which after getting the inserted values in variables tries to insert in another table.

following is the insert query which is giving error.

insert into tblDoctorPatient...

another reason to avoid them: Linq To SQL and Entity Framework side affects.

we just had an issue with transactions rolling back without any SQL error;

the issue was a linq to...