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

your sproc is accepting parameters. Without seeing all the code, it's hard to determine what might be wrong.

I'd suggest that you add a SELECT statement below this code to show...

Depending on the view, it's possible that you have cached the data after the first run and the second runs faster.

Without more information, it's hard to tell what might be...