You cannot force SQL to execute on shutdown, especially if someone uses SHUTDOWN WITH NOWAIT to force an instant shutdown.

In that case, let me jump in. 😀

There are many opinions of this subject, but I am firmly in the...

Michael Valentine Jones (11/21/2008)

---

What do you want it to return if today...

Jeff Moden (11/23/2008)

---

Not my idea, but... find's files for current database and makes a report of used, unused, and total size...

select [FileSizeMB] = convert(numeric(10,2),round(a.size/128.,2)),

[UsedSpaceMB] = convert(numeric(10,2),round(fileproperty( a.name,'SpaceUsed')/128.,2))...

This script will tell you the size of every table in a database.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

I don't understand why the OP is even posting his code here.

His failure to answer any of the requests for information on the expected results makes it impossible to offer...

The thread in that link seems to be about the amount of free space on the drives, not about the amount...

What do you want it to return if today is Sunday, today...

dphillips (11/20/2008)

---

Michael Valentine Jones (11/20/2008)

---

How about telling them the guy who was keeping the records of the backup tapes left years ago, was never replaced, and you don’t have any...

How about telling them the guy who was keeping the records of the backup tapes left years ago, was never replaced, and you don’t have any idea how to find...

There are a lot of people that post questions where they don’t even know how to ask the question, can’t make themselves understood in English, probably shouldn’t be working with...

The fastest way to get started is to use the Maintenance Plan Wizard.

You should also ready about Backup and Recovery in SQL Server 2005 Books Online.

The code below has a couple of options you can use:

select

next_run_date,

right(10000000+next_run_time,6) as Time1,

stuff(stuff(right(10000000+next_run_time,6),5,0,':'),3,0,':') as Time2

from

msdb..sysjobschedules

Results:

next_run_date Time1 Time2

------------- ------ --------

20081119 ...

Take a look at the stored procedure code I posted on this link. It should meet all the requirements you stated.

Generate Password Procedure

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78859

Have you verified that the tables that you don't see improvement on have clustered indexes?