Viewing 6 posts - 1 through 6 (of 6 total)
Here is the script after resolving minor issues with include and fill factor and added checking for index existence.
Very nice script though thank you.
DECLARE @idxTableName SYSNAME
DECLARE @idxTableID INT
DECLARE @idxname SYSNAME
February 24, 2012 at 3:35 am
DROP QUEUE YourQueueName;
Before you drop queue, you have to drop service (DROP SERVICE YourServiceName) attached to that queue so use caution and do your research.
June 12, 2008 at 9:22 am
No. But after I deleted the service broker queue which was not used, it cleaned up automatically. Not suer what triggered that.
June 11, 2008 at 7:09 am
I tried everything I can to remove/delete rows from that table but no help. When I try to delete/truncate I get the following error message
Cannot find the object "sysxmitqueue"...
May 16, 2008 at 1:11 pm
Thanks, all of you for your input, but I found solution yesterday itself my self, to share what i did is in the trigger I used dbcc inputbuffer(@@spid) using dynamic...
December 9, 2003 at 10:43 am
I am getting following error in the logshipping job for copying the log file from source server to standby server.
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
April 16, 2002 at 6:25 pm