The only real solution would be to offer your product only as a hosted solution where the users do not have direct access to the database.

If protection of your trade...

You should ask for what you need the first time, instead of posting a question, getting a reply, and then saying that what you really need is something else.

You can...

That is not true.

You need to read the "Shrinking the Transaction Log" topic in...

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...