Viewing 15 posts - 16 through 30 (of 70 total)
you have enabled trace flag 1222 to capture deadlock in error log.
DBCC TRACEON (1222, -1)
December 22, 2011 at 9:32 am
Nice presentation on Deadlock.
December 22, 2011 at 4:00 am
Its not possible to restore database from higher to lower version .. there is now way for Degrdation . you can script out the database objects without data ,create database...
December 22, 2011 at 2:54 am
Check physiacal IO or cpu is moving or not for that blockby process.?
December 22, 2011 at 2:44 am
Find below link for your question
http://http://msdn.microsoft.com/en-us/library/ms190679.aspx/
http://www.sqlservercentral.com/Forums/Topic490956-357-1.aspx
December 22, 2011 at 2:27 am
To Find SQL server instances in a local network
Simply
SQLCMD -L > c:\servers_filename.txt
You can also use powershell to get
December 21, 2011 at 12:36 pm
You can use SQL server Dashboard report feature. here is nice article which will full fill your requirements.
December 21, 2011 at 7:21 am
Can you post error message?
December 21, 2011 at 7:14 am
are you craeting you restore script from backuphistory tables from msdb. I am doubting below statement causing you the error. the 'NUL' is windows directory ,virtual decice which...
December 21, 2011 at 7:03 am
What is the exact command that you are using to restore point in time.
December 21, 2011 at 5:21 am
Here is also saying same.
December 19, 2011 at 11:47 am
Some examples of sp_help.
A. Returning information about all objects
The following example lists information about each object in the master database.
USE master;
GO
EXEC sp_help;
GO
B. Returning information about a single object
The following example...
December 19, 2011 at 11:22 am
Viewing 15 posts - 16 through 30 (of 70 total)