You need to shut SQL Server down for this to be safe and effective. I know people don't and vendors say it will work, but I'm not sure I trust...

AFAIK in this case it would be the same plan. An IN is a shortcut for multiple ORs.

What doesn't change? are you sure the record didn't have a null?

Run the query without the stored procedure, just the update. Does it work?

2005 up there, I'll do 2008 now.

The scenarios I saw weren't overly complex, but they cover a wide variety of add/edit/delete objects (add user, edit linked server, etc.), so the best thing is to be sure...

The inplace upgrade is a one-way thing. There's no easy rollback. You can uninstall, reinstall 2000, attach dbs, etc., but it's slow. If you have time, and people understand this...

It would be good to know if you're tracing the completed events, not sure if they require the final ACK from the client.

Are there stored procs or just T-SQL in...

you can snapshot replicate everything.

You can log ship, but that might cause issues with continuing updates.

You can automate the backup, write a script to copy the file (use the same...

I can add those, not sure they'll get posts 🙁

Nope, it's logged. Not sure what's wrong.

Interesting debates and comments here.

Both are important, and the code has to work. Good/bad, fast/slow, ANDI standard/old style, it has to work. If it doesn't work, it has to...

Paypal would really be to cover the majority of people early and get an idea of how many will attend for planning.

We could sell tickets at the door as well,...

What you'll learn? Hard to say, but you can search "PASS Summit" here on the site and we've usually gotten 2-3 people to write about it.

The conference is Wed-Fri,...

The permissions might be that the tables aren't there. I was thinking you were dropping the table to add the FK. Typically you do an "IF Exists" before issuing the...

Certificates implement asymmetrical encryption. I believe they encrypt a symmetric key, which is used to encrypt the data. Asymmetric keys have limits to how much data they encrypt, AFAIK.

PKI should...