Viewing 15 posts - 42,376 through 42,390 (of 49,571 total)
Jpotucek (12/15/2008)
What - if any - damage could I cause if I dropped the non-unique - non-clusered index and left the clustered/unique PK index???
There shouldn't be any damage
the...
December 15, 2008 at 1:55 pm
Ok...... Never seen that before.
If it's stack dumping, you need to call customer support.
December 15, 2008 at 1:47 pm
dbdbdb (12/15/2008)
Let me clarify my certification goals at this point:MCITP: Database Administrator 2008
MCITP: Database Developer 2008
MCITP: Business Intelligence Development and Maintenance 2008
Do you do dev, admin and BI?
Now as I...
December 15, 2008 at 1:42 pm
By unrecoverable, do you mean the deadlock detector's not picking it up? Does having traceflag 1222 on result in a deadlock graph in the error log?
December 15, 2008 at 1:36 pm
Not enough information.
Can you post the message 1 line above that in the error log. The one that reads Error ... Severity .. State ...
With a login failure, the...
December 15, 2008 at 1:24 pm
December 15, 2008 at 6:58 am
Post the deadlock graph please?
To get deadlock graph, turn traceflag 1222 on. Deadlock graph will then be written into the error log everytime a deadlock occurs.
December 15, 2008 at 6:51 am
sanjeev_krs2004 (12/15/2008)
HCan any of you guide me how to delete the transaction logs without accessing the database.
Never ever delete transaction logs. It's the fastest way to get a corrupt and...
December 15, 2008 at 6:50 am
Restore is what you do with backups. Take the backup file and turn it back into a database.
Recovery is something that SQL does every time it brings a database online....
December 15, 2008 at 4:43 am
Rich Caine (12/10/2008)
How could I change the sub query above to get the highest DateCreated yet still return Versions.Ref (which I need in the emcompassing join)?
If you change the subquery...
December 15, 2008 at 4:33 am
ps (12/15/2008)
Even if the database is online; since i'm restoring the primary filegroup, i need to put the database in single_user mode right?
It's never necessary to put a DB into...
December 15, 2008 at 4:09 am
Is the database still online?
SQL 2000, 2005 or 2008?
December 15, 2008 at 1:02 am
ps (12/14/2008)
You can move those four tables in a different database file. take file/filegroup backup. You'll be able to restore them.
You'd still need to backup and restore the primary filegroup...
December 15, 2008 at 12:25 am
viji (12/14/2008)
expecting a advice...
December 15, 2008 at 12:19 am
Viewing 15 posts - 42,376 through 42,390 (of 49,571 total)