Friday, November 11, 2005 - Posts

Job Schedules in SQL Server 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Job Schedules in SQL Server 2005
The new RSS feed is here

For years now one aspect of SQL Server has bugged the hell out of me, but as time goes on some things you just accept.

Job Schedules, I have never understood why you have to create a new schedule for every job you create.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Job Schedules in SQL Server 2005

posted Friday, November 11, 2005 5:15 PM by SimonSabin with 1 Comments

Enabling Database Mirroring in SQL Server 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Enabling Database Mirroring in SQL Server 2005
The new RSS feed is here

You need to turn on a trace flag to enable database mirroring in the RTM version of SQL server 2005. A list of trace flags is listed here

http://msdn2.microsoft.com/en-us/library/ms188396.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Enabling Database Mirroring in SQL Server 2005

posted Friday, November 11, 2005 12:03 PM by SimonSabin with 1 Comments