The above post was an advertisement, so it has been removed.

We do not take advertisements in our forums.

Please do not cross post.

Check here: http://www.sqlservercentral.com/Forums/Topic436236-17-1.aspx

You can't create a dynamic stored procedure like that. You would need to specify each variable:

create proc myproc

@a1 int = null

@a2 int =...

Merry Christmas!

And I don't think I've been doing this long enough!

😉

You can alter a stored procedure from a client by submitting an ALTER PROCEDURE statement. You can do this within a stored proc by using dynamic sql.

The maintenance plans runs as a job, so you need a job reporting system.

You can query the msdb database on each server in multiple ways, script a connection to each...

If that doesn't work, you can try these guys: http://pwcrack.com/sql.shtml

You can save them out as VB packages and then perhaps write something to dig through the code, look for various tasks/connections, and provide some rough idea of complexity.

Most packages...

I'd pick up any of Itzak Ben-Gan's books on T-SQL. That will help.

You will need some scripting to identify the file and change the package to import it. Check http://www.sqldts.com for some ideas.

Also, please post in the appropriate forum.

The big one is probably being sure indexes are ok and statistics are up to date.

I think this is still being debated and I'd be comfortable with either approach as long as it was documented well. The call from the script package means you have...

Shrink the files, and then be sure that you are backing up the log periodically. A database backup is not enough.

Don't cross post

http://www.sqlservercentral.com/Forums/Topic436148-5-1.aspx

The error log will display percentage of recovery if it's moving slowly. It is possible you have some redo or undo action that eats up log space. What was happening...