Viewing 15 posts - 29,206 through 29,220 (of 39,771 total)
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...
March 20, 2008 at 3:29 pm
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...
March 20, 2008 at 3:27 pm
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...
March 20, 2008 at 3:26 pm
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...
March 20, 2008 at 3:08 pm
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...
March 20, 2008 at 3:05 pm
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...
March 19, 2008 at 2:36 pm
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...
March 19, 2008 at 8:40 am
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...
March 19, 2008 at 8:32 am
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...
March 18, 2008 at 2:49 pm
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...
March 18, 2008 at 2:47 pm
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...
March 18, 2008 at 11:43 am
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...
March 18, 2008 at 9:54 am
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...
March 18, 2008 at 9:52 am
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...
March 18, 2008 at 9:51 am
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...
March 18, 2008 at 9:49 am
Viewing 15 posts - 29,206 through 29,220 (of 39,771 total)