Glad you enjoyed it and both a few friends and my son have asked it we can do this. We may give it a try sometime!

Do you mean store the current password?

Search sp_help_revlogin and this will script out the logins and hash of the current password.

Does the account have rights to get to the backup folder? When you say you changed the server, does that mean that you changed the service account?

It's not quite...

Bobby,

We can help, but please take a few minutes to read your post and then correct the grammar so it can be read and explain it a little clearer. You...

First this is a lot of code to go through. I'd suggest you break it down and get one part working.

The insert into the temp table needs to be separate...

Locally your credentials probably work using SQL Express. When you go to an IIS situation against a remote server, the IIS account is what is used to connect, not your...

It's hard to give advice here because the education is partially an investment for your career, but partially an investment in yourself. You will make contacts and enhance your knowledge...

I think this would need to be an option, both on backup (keeping v skip indexes) and restore (rebuild or not), but I don't see where there's a problem with...

Ahh Major, if you get over to Denver in the summer we'll get you out there for a Billy Crystal moment and see how you like baseball 😛

http://news.bbc.co.uk/2/hi/entertainment/7289502.stm

http://nbcsports.msnbc.com/id/23566549/

I agree that...

I got a PM as well and I'll close down this topic since we've slightly wandered away from the question. I did explain that I thought he/she hadn't done enough...

When you connect, you use your credentials, likely your Windows account. When the web service connects, it's probably using different credentials, probably IIS credentials. Be sure those have access to...

That's really strange as the snapshot creation should not be doing anything. Is this during periods of heavy change to the main database?

Only thing I can think is that there...

I think the biggest benefit for many people is that CTEs allow them to write complex SQL in an easier way. Moving to derived tables just seems harder for many...

The big thing that Greg mentioned is to load in chunks, or reduce the batch size. If you load with BCP, there's a setting to commit after xxx rows, same...

What I've heard is that if the image is < 250-300kb, store it in the db. If it's above that the filesystem works best. If it's used often, I'd use...