You can't easily do this in the maintenance plan. There needs to be logic to find the latest file, or read the msdb tables, to do this. It's not trivial,...

Nope, you can perhaps implement some loops to do this. I've used bcp to do this before. Some scripts on this site to help.

Best bet is build the DTS package,...

This can be tricky, and I don't think MS has done a great job explaining.

I've tended to look at BOL here (http://msdn.microsoft.com/en-us/library/ms190673.aspx) for guidance.

My understanding was AWE wasn't needed...

Bottom line: buy more disk space.

Permission to syscomments somehow?

Honestly the way to handle this is ensure your code is in a version control system. Keeping it on the server isn't really VCS.

I believe if you query Access, it goes through the DSNs configured inside the Access db to get to the data.

For the SQL stuff, you can setup a DSN the...

why cluster on VendorServiceID? You can have a primary key that's non-clustered.

Use the clustered index for one of the dates since they're often queries in ranges.

I don't think that <...

Search for cross tab queries.

There isn't an easy way to do this. You can do with with self joins, i.e.

select a.colA + ',' + b.colA from tableA a inner join...

Why would you need to know how many records in every table have been changed? That seems strange. I could see a few of them, but wouldn't lots of tables...

Keep posting here, and we'll try to help.

Honestly, I'd recommend you beg for some $$ to pick up one SQL 2005 book, any of the admin books (check half.com) and...

Also, is the code always slow? If you run it 10 times in the db and in tempdb, is it always slower in tempdb?

If the code is the same, why not deploy it to each database and call the code directly without worrying about dynamic SQL?

Having 40 copies of stored procedures in 40...

Are you moving all data from this table? You could move the clustered index (rebuild on the new file) instead. Not sure if the image data moves, but I would...

that is strange. Does it compile without the db name reference? Shouldn't matter, but not sure why this is a problem.

Some good advice, and there are a few articles on this site (search naming conventions).

I try to get things to group, since that's how I use them. So everything with...