Viewing 9 posts - 1 through 9 (of 9 total)
See if any UMS threads are running..
You can use this undocumentated DBCC command and see if there are any blocks.
August 12, 2004 at 12:32 am
If you are restoring the master database and also the other system databases where on the different drive to the destination location SQL server wont start they have to be...
March 25, 2004 at 7:21 pm
When ever the jobs fail to send the notification , first try to send a mail through SQl query analyzer and if it is successful means problem with the agent...
September 10, 2003 at 12:49 am
Apply same service packs both on the server and client accessing machine.
December 9, 2002 at 6:17 pm
Hey we had the same problem
and the reason is that when you are using SQL7 with service pack 2 and if you are using xp_sendmail through DTS package
October 29, 2002 at 5:38 pm
we use snapshot replication because we do not require the most recent data and the data at the publisher changes once a day/couple of times a week and these are...
October 10, 2002 at 12:55 am
May be MSSQLServer and SQLServerAgent services are using the System Account.
check that these accounts are using domain accounts.
Edited by - ramesh on 10/10/2002 12:02:07 AM
October 10, 2002 at 12:00 am
I would go for something like this as it is very easy to read and
you can see the columns being selected,How many tables being referenced and
the join conditions pretty...
August 20, 2002 at 7:36 pm
This article has both Pro's and con's but as a practice the applications are developed using Windows Authentication it is really hard to digest this so easily .
July 15, 2002 at 12:06 am