We have merge replication and we no longer need replication. when we are trying to delete a article the transactional log is being filled up. Can...
I need patch MS02-061 for Sql Server 2000. Microsoft site no more has that. Can anyone guide me where can I get the patch
Hi, I am looking for a script that monitors the backup jobs and send mail for the failed jobs across all the Sql Server 2005 servers. I have a...
I tried that but not successful
Hi, I tried to remove the publication on the server and I am getting the message "Error 2812: Could not find stored procedure". Please help me on...
The maintenance plan is edited from the client which has service pack 2 installed on it and the actual server doesnt have service pack installed on...
I had to change the collation order in Sql 2005 at server level and not the database level. Do I have any option of doing that other than...
thank you very much
Hi, I have ten databases in a server can I know which database is having how many hits or which is the busiest one. Regards Madhu
The db name is CLAS
USE [msdb] GO /****** Object: Job [CLASSTEST DB Maint Plan - Daily] Script Date: 04/09/2007 14:15:41 ******/ BEGIN TRANSACTION DECLARE...
Hi, I have a merge replication in our company and we want to delete that.In order to delete the publisher I need to delete the articles in the...
Hi, when i try to run the job it is failing and I am getting the followng message. Message Unable to start execution of step 1 (reason: line(1):...
Separate names with a comma.
