My preference would be VS, or ssrs, just not sure how to approach it.

Yes - I do agree. This will give a good opportunity to free up some space as well with the full backup/restore method, and faster as well. I...

Thanks for all the great advice and scripts. I decided I was going to go with the option of scripting the detach/attach and then just transfer the data and...

I like that idea, but will need to script it to do all databases at once, in scripts as there are so many databases. Then script the attach as...

I was able to manipulate it a bit into my scenario, and worked Perfectly!! Then added to the rest of the solution, and everyone is happy! Thanks...

Luis - first of all - Thanks so much for the solution! Secondly - you are correct, I don't post much to the forum and usually have pretty good...

Very strange - so I am was looking at one of the servers that this is running on and failing - and after looking through the history is turns...

Looking at another server that is runnig the same script and the error it is getting is "COUNT field incorrect or syntax error [SQLSTATE 07002] (Error 0). The step...

So here is an odd update. It fails when it is running at night (normal time), but just for kicks I ran it this morning and it acually ran...

Good afternoon -- I have an odd question - I have been using this scipt on a few of my servers for a while now, and just recentyl...