SQL will let you know if you're out of order. Typically you're restoring by times anyway.

Be sure that you always restore with NORECOVERY. You can always bring it online later,...

Well

, I think leading commands are

, well

, easier to read

:hehe:

No difference. This forum software allows for multi-threaded posts (replying to a specific post), but we have removed that. All discussions are single threaded to avoid confusion.

There must be some process that is changing the mode. You might need to run a trace to try and catch this, or run a script that checks it every...

Please don't cross post. Reply here: http://www.sqlservercentral.com/Forums/Topic451573-150-1.aspx#bm712110

Feeling hungry, pork chops sound good this am 😉

Honestly, I don't think this is a DBA's job. I was curious if anyone would bring it up, but there should be someone doing compliance, that looks over the DBA.

That...

For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:

However, I do think that in your...

Have you tried to run it interactively to see where it's failing?

Actually you would typically "retry" a couple times if you get the duplicate error.

The chances of there being two inserts at the same time is extremely small, so likely you...

This thread feels like a Twitter stream.

Bruce,

That is how I'd do it as well, but does that guarantee there can't be a collision? Could not two people potentially run the SELECT and IF NOT EXISTS at...

We are supposed to get 1 dev/week a month, and we are looking to hire 1-2 devs to work on the sites (Simple Talk and here) regularly.

Not sure where this...

OK, new avatar. This is what I ask myself when I look in the mirror.

It doesn't always return 1. If you were to collide on concurrency, both insert a Userid = 1, then you'd get 2, then you'd know there's a collision.

However, can you...