Viewing 11 posts - 196 through 206 (of 206 total)
There is a lot Dos cmd command for Cluster management. So we can use them via xp_cmdshell.
http://technet.microsoft.com/en-us/library/cc779044(v=ws.10).aspx
July 17, 2012 at 11:05 pm
Activity Monitor can help you if you have sql 2005>.
July 17, 2012 at 10:27 pm
if you problem solved, plesae post that...
did you have problem with port number?
July 17, 2012 at 10:20 pm
This link can help you.
For this, you need to enable database mail(sql server 2008/2005) or sqlmail (sql server 2000
July 17, 2012 at 9:55 pm
Check for orphaned users.
Check for Cross-database ownership issue.
July 11, 2012 at 3:40 am
to access sql agent jobs, a login needs to be assigned SQLAgentUserRole, SQLAgentReaderRole and SQLAgentOperatorRole (Operator is the most privileged one)
http://msdn.microsoft.com/en-us/library/ms188283.aspx
to run SSIS packages, you may need a...
June 27, 2012 at 11:28 pm
Better post the Execution Plan.
June 26, 2012 at 9:31 pm
Did you try with multiple destination backup files? also try to increase BufferCount, MaxTransferSize and BlockSize Parameters.
Test these scenario in a dev environment before production.
June 26, 2012 at 1:12 am
refer this link to see if it helps you.
June 21, 2012 at 10:55 pm
If i understand correctly, If your table has any non clustered index which might not be included in your REBUILD. Rebuild operation will only do "update statistics" of the concerned...
March 16, 2012 at 7:43 am
Viewing 11 posts - 196 through 206 (of 206 total)