Microsoft SQL Server Articles
Links, articles, scripts, tips, and other technical sources for managing SQL Server. DBALinks is dedicated to SQL Server and database administration.
ABOUT SQL SERVER
Articles | Categories | Search | Syndication
If your msdb database grows huge - it is because of sysxmitqueue table.
ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER
DATABASE [msdb] SET NEW_BROKER WITH ROLLBACK IMMEDIATE
DATABASE [msdb] SET MULTI_USER