Viewing 4 posts - 76 through 79 (of 79 total)
First Check for any open transactions in Tempdb by running below query.
DBCC OPENTRAN
if you get below results means,start to shrink the Tempdb files.
dbcc opentran
--No active open transactions.
--DBCC execution completed. If...
Regards,
Kumar
September 9, 2011 at 4:00 am
Hi,
Check cluster.log in the cluster installation path and based on the failover message log,set your monitor.
Thanks
Kumar
http://sqldbataskwithkumar.blogspot.com
Regards,
Kumar
July 27, 2011 at 8:14 am
Hi ,
Go to Enterprise manager->Right Click SQL server Group->Fill All details
Then Register SQL server by expand SQL server Group and choose New sql server registration.
Fill with sql authenticated credentails.
thats's...
Regards,
Kumar
June 1, 2011 at 1:31 am
How to view dtspackage error log in a table?
select * from msdb..sysdtssteplog order by endtime desc
select * from msdb..sysdtstasklog order by endtime desc
select * from msdb..sysdtspackagelog order by logdate...
Regards,
Kumar
May 11, 2011 at 8:55 am
Viewing 4 posts - 76 through 79 (of 79 total)