Viewing 15 posts - 34,576 through 34,590 (of 49,552 total)
Lynn Pettis (1/19/2010)
January 19, 2010 at 1:06 pm
You're running SQL 2000 there, not SQL 2005.
January 19, 2010 at 1:05 pm
Chad Crawford (1/19/2010)
The drive came back ok when the network came up, but SQL Server didn't 'reconnect' to the file.
It doesn't. Once SQL detects that a drive...
January 19, 2010 at 12:50 pm
Lynn Pettis (1/19/2010)
GilaMonster (1/19/2010)
Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page protection.
Oh,...
January 19, 2010 at 12:49 pm
Lynn Pettis (1/19/2010)
My concern is the drive being powered off possibly causing data corruption.
It may have. Or it may not have. Impossible to tell without running a checkDB, which is...
January 19, 2010 at 12:48 pm
You need to set a default on the column. Look up ALTER TABLE for the syntax to do so.
January 19, 2010 at 12:31 pm
gregory.anderson (1/19/2010)
GilaMonster (1/19/2010)
How...
January 19, 2010 at 12:29 pm
Lynn Pettis (1/19/2010)
January 19, 2010 at 12:28 pm
Please run the following and post the results
SELECT @@version
January 19, 2010 at 12:21 pm
I'd suggest a reboot. Once SQL's back online, run a checkDB on the original database, see if everything's OK.
You probably didn't need to restore the database, very likely once the...
January 19, 2010 at 12:20 pm
Take a look at this series
http://www.brentozar.com/becoming-a-dba/how-to-get-a-junior-dba-job/
January 19, 2010 at 12:18 pm
That's not a compete output and I cannot see from that what's wrong. Where did that come from? Looks like just the job history.
January 19, 2010 at 12:08 pm
Ramji29 (1/19/2010)
update master.sys.sysdatabases set status = 16 where name = 'db'
Even ignoring that 'allow updates' is ignored on SQL 2005, sysdatabases isn't even a table any longer. It's a view...
January 19, 2010 at 12:06 pm
Scans of the clustered index are table scans. They either indicate that a nonclustered index was not selective enough to be used, or there are nonclustered indexes missing.
How did the...
January 19, 2010 at 7:08 am
Viewing 15 posts - 34,576 through 34,590 (of 49,552 total)