A few clients will connect directly, but the majority of users pass though an application that is managed on a Citrix Server.

your login may not be mapped to the user account. Have you switched servers lately?

in this case the in and the or will produce the same results...... right?

I agree with Grant Fritchey.... I spent countess hours studying to pass the exams; only to find that the questions were not related to a live interview. My...

@jeff Moden

What is "but there can be a lot of other baggage that goes along with it" referring to when you mentioned it in your comment.... I was just...

I guess in this situation, your rentention period should be considered. How much data are you able to lose (if any)? My current backup plan consists of 48...

Creating a share where the file exists, then giving the account MSSQLSERVER rights to the folder worked like a charm... Thanks all

Is the orders numbers are already apprear one after another wouldnt just selecting a MAX(orderid) from "your table" work?

Thanks for posting the resolution

Are you utilizing NUMA?

Up to 8 replicas was a new enhancement which was applied to SQL Server 2014. SQL Server 2012 only supports up to 4. If you are taking a...

did you check the services?

I tested it and it was a different error.... See attached

I'm sure you have already looked into it, but I have made the mistake in the past where I would try to update on the node were in the DB...

Yes