Viewing 15 posts - 4,651 through 4,665 (of 18,926 total)
Can't be?!?!?
How big is the DB? How much data was there in it before the accident happened?
July 20, 2011 at 2:02 pm
DBCC CHECKDB() WITH NO_INFOMSGS, ALL_ERRORMSGS
July 20, 2011 at 1:55 pm
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
Now you just...
July 20, 2011 at 1:48 pm
This is what I do, applies the same base principles :
July 20, 2011 at 1:44 pm
Try running the code in SSMS and see if you get a mor specific error.
July 20, 2011 at 1:43 pm
I never meant to imply that she's unhappy. I'm sure she'll be back soon but then again it's close to midnight now where she lives.
In SQL 2000 the "ALTER...
July 20, 2011 at 1:36 pm
Jack Corbett (7/20/2011)
Congrats to Lynn on the first grandchild.
Congrats to Jeff for the Exceptional DBA nomination.
Training:
There is definitely...
July 20, 2011 at 1:10 pm
Kiara (7/20/2011)
Ninja's_RGR'us (7/20/2011)
Please join in on the fun and tell us about the last time you felt foolish about yourself!
Oh, that happens on a daily basis! 😀
Yesterday morning I...
July 20, 2011 at 1:07 pm
halifaxdal (7/20/2011)
Ninja's_RGR'us (7/20/2011)
halifaxdal (7/20/2011)
DBCC CHECKDB(CheckListDB_Data, REPAIR_ALLOW_DATA_LOSS)
failed with
Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'CheckListDB_Data'. No entry found with...
July 20, 2011 at 1:04 pm
halifaxdal (7/20/2011)
2011-07-20 12:02:46.81 spid14 Starting up database 'CheckListDB'.
2011-07-20 12:02:46.84 spid5 Starting up database 'tempdb'.
2011-07-20...
July 20, 2011 at 1:03 pm
halifaxdal (7/20/2011)
DBCC CHECKDB(CheckListDB_Data, REPAIR_ALLOW_DATA_LOSS)
failed with
Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'CheckListDB_Data'. No entry found with that name....
July 20, 2011 at 12:57 pm
Ah!!, glad you got it figured out.
July 20, 2011 at 12:55 pm
SELECT
MAX(CASE when batchid = G001OSX1 then v1 = 219 ELSE NULL END) AS V1,
MAX(CASE when batchid = G001OSX2 then v2 = 219 ELSE NULL END) AS V2,
MAX(CASE when batchid =...
July 20, 2011 at 12:47 pm
Viewing 15 posts - 4,651 through 4,665 (of 18,926 total)