Viewing 15 posts - 17,086 through 17,100 (of 39,831 total)
After removing SQL Server 2008 from your workstation? I assume you mean you are getting this when you open Ss2K5 Management Studio, correct?
You might need to reinstall the SS2K5 tools....
January 8, 2011 at 9:31 am
Some good advice from Craig here. If you need a consult, even remotely, I have a few people I would recommend. They can likely give you some suggestions for a...
January 8, 2011 at 9:29 am
This (http://www.sqlservercentral.com/Forums/Topic1043954-146-2.aspx), IMHO, is a great example of why it's good to have multiple articles or blogs on a topic. Elliot and I seem to be saying the same thing,...
January 8, 2011 at 9:20 am
Javascript is amazing. It makes web pages so much more interactive and interesting. It runs in a fairly low privileged manner under your account, and it's an amazing language.
It's also...
January 8, 2011 at 9:16 am
I think it's more a question of how small is it until you get the "yes-it's-the-whole-fist-customer-service" treatment.
January 8, 2011 at 8:59 am
Mark has written a nice suggestions, but it would be nice to know *how* you back up the database and then shrink the log.
- a full backup does not...
January 8, 2011 at 8:54 am
Good thought, Gus.
A few wait stat posts:
http://www.sqlservercentral.com/blogs/sqlrnnr/archive/2010/12/13/wait-stats-resources.aspx
January 7, 2011 at 1:06 pm
Eric has summarized nicely what I would do.
One note, be sure adding the identity will not break other code.
January 7, 2011 at 1:04 pm
qur7 (1/7/2011)
Now...
January 7, 2011 at 1:03 pm
qur7 (1/7/2011)
Dont want to sound too much of a rookie but how would I proceed after that ...
lets say based on your code the value is...
January 7, 2011 at 1:02 pm
Elliot, we are not disagreeing. I was responding to the OP as a clarification. What you have written is correct, but this is not a difference because of the OS...
January 7, 2011 at 1:01 pm
cengland0 (1/7/2011)
mtassin (1/7/2011)
Transaction log backups are not a major change. It's a backup. SQL server does the rest.
I disagree -- it is a major change. If it...
January 7, 2011 at 12:56 pm
I am wary of backing up to the same file every time. It is asking for an issue. What if the tape failed, you didn't fix things, and your backup...
January 7, 2011 at 10:57 am
If the log needs the space, you're going to run out of space anywhere. A log backup allows the log space to be re-used and overwritten.
Feeling like the log...
January 7, 2011 at 10:21 am
You are welcome.
This might help you for future questions: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 7, 2011 at 10:18 am
Viewing 15 posts - 17,086 through 17,100 (of 39,831 total)