EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'REPL-Alert Response' /***** Object: Step [Send e-mail in response to WMI alert(s ...

This script creates a new database 'DataWarehouse' under Master database after checking if it already exists. if the database exists then it is dropped and recreated. Additionally, the script sets up ...

Of all the tools that ship with SQL Server, Enterprise Manager is by far the most feature-packed and widely-used. Nearly every SQL Server developer is familiar with Enterprise Manager. They are ...