Viewing 15 posts - 931 through 945 (of 1,363 total)
Do you have any id avaialable which is sysadmin on this instalation so that you do these single user stuff and issuing a command from command prompt.
MJ
November 26, 2008 at 9:14 am
First create a alert of type(SQL Server Event Alert) and then chose severity of 016(Misc. User Error) for all databases. Then specify message text as "Blocking Threshold" . Then finally...
November 25, 2008 at 2:36 pm
Try executing the below code from management studio:
!!Sqlcmd -S Servername -E -d northwind -Q "Select * from employees" -o C:\output_file.csv -s ,
-s switch specifies the column-separator character. The default is...
November 25, 2008 at 2:15 pm
Start from http://support.microsoft.com/?kbid=271509
MJ
November 25, 2008 at 9:56 am
Mani,
Try this. Connect to ur sql server in normal mode(no single user mode) and open a query analyzer window and stay in it. With this window open do the rest...
November 25, 2008 at 9:32 am
Try connecting thru query analyzer and post the error message.
MJ
November 24, 2008 at 5:16 pm
What exactly you want to capture?
MJ
November 24, 2008 at 4:18 pm
What is the eror message tht u get when u try to connect from EM? Try thru query analyzer too..
I think u r trying to do the restoration of master...
November 24, 2008 at 4:13 pm
November 21, 2008 at 5:05 pm
Run this:
Update dbo.ReportblCust
Set ValidMsgDisp = Source.ValidMsgDisp
From
ReportData_DPS.dbo.ReportblCust Dest Join
ReportData_DPSTest.dbo.ReportblCust Source On
...
November 21, 2008 at 4:59 pm
Invoke the second job on completion of first job by calling it under second step by making use of sp_start_job stored procedure.
http://technet.microsoft.com/en-us/library/ms186757(SQL.90).aspx
HTH,
MJ
November 21, 2008 at 4:24 pm
Have you tried steps mentioned under http://kendalvandyke.blogspot.com/2008/11/delegation-what-it-is-and-how-to-set-it.html
MJ
November 20, 2008 at 4:33 pm
Have you tried executing the backup statement urself under mgmt. studio or query analyzer?
MJ
November 20, 2008 at 2:45 pm
This option is available only 2005 onwards.
MJ
November 20, 2008 at 9:52 am
Viewing 15 posts - 931 through 945 (of 1,363 total)