Use the DBCC SHRINKFILE command.

You can look it up in SQL Server Books Online.

Use the SET DATEFIRST command.

You can look it up in SQL Server Books Online.

So how do you do this with people that work remotely or if you work remotely?

You can query the msdb sysjob* tables to get this information.

You need to start by providing a good definition of how the week of the year is determined.

Week of the year is something that has different definitions in different organizations.

Your objections to the scripts SQL Server produces seem trivial, and more a matter of personal choice than any actual problem with them.

I have never had any problems running the...

There isn't very much that runs when, for example, the server loses power.

You really need a monitoring tool running on another server. You might check into HP OpenView or...

I don't see anything wrong with the first script, and it ran clean for me.

I don't really like your script, since you are letting SQL Server name a database object...

You can pick the data from this query that you need.

select

a.*,

b.*

from

msdb.dbo.backupset a

join

msdb.dbo.backupmediafamily b

on a.media_set_id = b.media_set_id

Where is this script going to be running when the server is down?

select

LastDayOfMonth = dateadd(month,((yr-1900)*12)+mn,-1)

from

(

--Test Data

select yr=2008,mn=1 union all

select yr=2008,mn=2 union all

select yr=2008,mn=3 union all

select yr=2008,mn=4 union all

select yr=2008,mn=5 union all

select yr=2008,mn=6 union all

select yr=2008,mn=7 union all

select yr=2008,mn=8 union all

select yr=2008,mn=9 union...

I started night school with one year of full time school completed, so I was able to finish in 4 years by taking 8 classes per year, 3 each in...

There are places that will not consider someone without a bachelor’s degree because a high school diploma is no longer sufficient to demonstrate the most basic of job skills, the...

If you have a whole week to get if from LA to SF, back it up on tape in LA, ship the tape to SF overnight express, and restore it...

You made it too complex....