check to see how long your history retention is; it could easily have been written, but aged out by the time you look at it.

if it is still a the...

it's been a while on this thread, but i had this occurred to me twice since i last followed up on this;

here's some notes i took about the service broker...

I'm guessing it has something to do with collation.

can you run these commands, and report what the values are?

with that, i could replicate the issue, ib et:

select databasepropertyex(db_name(),'collation')

select databasepropertyex('master','collation')

bgrossnickle are you using the original code fromt eh article, or the updated code from the discussions here?

over the years, we've made a lot of improvements; your example table...

you can also do a shift + Right Click on the item to get a Run As Different User context,w here you can put in the other domain credentials.

limiting access to an existing workbook would simply be permissions on a file share, right?

I don't think you need powershell for that, just assign the right permissions to a folder...

you posted in SQL2008 forum, so my questions are for that platform. i think you might be posting a MySQL question in a SQL Server centric forum though.

Since SQL Server...

did you already grab the General Equivilency Mapping stuff?

https://www.cms.gov/medicare/coding/icd10/2015-icd-10-cm-and-gems.html

your example is a great one how codes don't have exact equivelents

in the file for ICD9 to OCD10, 250.00 maps to E11.9,...

GonnaCatchIT (4/15/2016)

---

Thanks for the inputs.

I tried increasing the timeout to a 1 hour , but still get the same issue.

If the Query plans are being generated differently on 2 environments....

we can't help you with homework, but if you have specific questions you can't seem to get right, if you show us what you've done,we can offer suggestions.

If i...

the If does not shortcut the validation for objects and columns. all objects must exist before the statement executes. you see the smae behavior if you have an ADD column...

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...