If it's just looping over all the tables, you can do that with a while loop (but since it's still completely procedural, I classify this as cheating :-):

1. Create a...

It could also be built with a derived table, I think -- if you REALLY want it in one query 🙂

Now THAT is clever. Wow.

I wonder what someone would do who came upon that device in an existing database, without knowing what it did :-). Quite a puzzle!

What is the line

SELECT RC = @rc

?

My 2 cents - you save a lot of energy and heartache by simply ignoring the gaps. They do no harm. 🙂

The philosophy I like to follow is like Chris':...

Have you tried single quotes around the date?

Also, 2 cents: the structure of the stored proc uses a string to compose dynamic SQL, which will work but might not be...

It's pretty simple to script a restore from backup -- in my firm we do that for training and development copies of our production database. You could write the restore...

Check out BOL under CREATE PROCEDURE WITH ENCRYPTION

I usually use DTS for that type of thing. Can you handle it that way?

Does this help?

select tbl.[name] as TableName,

idx.[name] as IndexName,

indexproperty( tbl.[id], idx.[name], 'IsStatistics') as IsStats,

indexproperty( tbl.[id], idx.[name], 'IsAutoStatistics') as IsAutoStats,

indexproperty( tbl.[id], idx.[name], 'IsHypothetical') as IsHypothetical,

indexproperty( tbl.[id], idx.[name], 'IsClustered') as IsClustered,

index_col( tbl.[name], idx.indid,...

I don't think it's possible to "stretch" stored procs to do what you are attempting. If it were me, I'd head toward just troubleshooting the script instead ... then run...

AFAIK, you can't issue Create Trigger inside a stored proc. BOL: "CREATE TRIGGER must be the first statement in the batch and can apply to only one table."

Can I ask...

Great article! Very informative. Thanks so much for taking the time to write this up. As I am about to move a database myself, it's quite timely.

One minor, even picky...

Would some flavor of this work?

SELECT top 1 count( column ) , column

from table

where [your conditions]

order by count( column ) desc

I also like Idera Diagnostic Manager -- we just completed a comparison test of monitoring tools, using demo licenses, and it was the clear winner for what we needed to...