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

You can't drop the certificates and symmetric keys.

You need to slow down and carefully understand what is happening. When you create encryption, you

1. Create DMK

2. Create certificates/asymm key protected...

And Grant like his?

Actually it wasn't that cold. This Fridays' podcast was shot then, in a T-shirt, outside. I was a little cold, but not unbearably.

You can use a maintenance plan with only a maintenance cleanup task to delete backups.

I think we agree, and you've stated it better than I did.

Logged as a bug