Viewing 15 posts - 20,731 through 20,745 (of 39,961 total)
The answers have been edited to include the column and "none of the above" has been changed. I will award back points. My apologies as I didn't notice the missing...
February 26, 2010 at 8:29 am
This is SQL Server 2005 Developer edition, correct?
February 25, 2010 at 4:41 pm
Did the database grow? Could autogrow have jumped by xxGB?
February 25, 2010 at 4:40 pm
The code is SSC2010
It takes $100 of the early bird rate
February 25, 2010 at 4:39 pm
Have you limited memory for both instances? If not, they will be fighting for resources and causing issues.
February 25, 2010 at 3:57 pm
The dates have been edited. Much of this is from last year, but there are a few new items.
February 25, 2010 at 3:43 pm
What's the error? You have put something in the subject, but that doesn't show up. The error needs to be in the post. Also, there are some non-English characters in...
February 25, 2010 at 3:41 pm
SQL is Structured Query Language. It's a language designed for querying sets of data (http://en.wikipedia.org/wiki/SQL)
SQL Server is a RDBMS, database product, from Microsoft. It is built to run on Windows,...
February 25, 2010 at 3:40 pm
I work for Red Gate, but their tool or any other compare will do this very inexpensively. It sounds like a decent sized purchase for your boss, but consider your...
February 25, 2010 at 3:36 pm
Those white papers cost money. The payback is salesman contacting people and making some sales. It's the same thing for contests. They pay for the prices when making a few...
February 25, 2010 at 8:05 am
You can use the DAC if you are a local administrator to connect and reset things
http://blogs.msdn.com/sqlexpress/archive/2005/09/08/462609.aspx
February 25, 2010 at 8:03 am
So, in addition to doing a restore, you need to check your hardware. This could happen again.
February 25, 2010 at 8:02 am
Did you upgrade SQL 2000, or add a 2008 instance or do something else? If you have two instances, you might be eating up memory as well.
February 25, 2010 at 8:01 am
Have you run this from just SSMS or SQLCMD?
I doubt this is corrupting tempdb, but it would be good to run this without a VB client to see more details.
February 25, 2010 at 8:00 am
As a hint, a cross tab or PIVOT might be what you need.
February 25, 2010 at 7:59 am
Viewing 15 posts - 20,731 through 20,745 (of 39,961 total)