wow, I've never expected a vacation for turning in notice. I'm surprised that valued employees would feel that way. Changes my definition of "valued"

This sounds like something that would be fun, reduce work load, reduce phone calls. Wouldn't you want to enjoy this and delete them one by one :D:w00t:

I might suspect that the services are not started then. You want to use SQL tools, not the Windows ones to work with SQL Server.

Moving to SQL 2005 Admin

I might suspect that the services are not started then. You want to use SQL tools, not the Windows ones to work with SQL Server.

Moving to SQL 2005 Admin

I think SQL is a flat file database for the engine. Extents, pages, they're laid out like a flat file. Every flat file has some level of meta-data in it,...

Crazy, if you're getting that many, fire up Profiler and get a check on what might be kicking it off. I haven't heard of this happening, but you never know.

You should not need to on a detach/attach type move, but you never know. When the files are copied, it's possible they get more fragmented, and a rebuild might clean...

Lots of MVPs are highly technical and tend to have a high opinion of their own work and opinions. Some of that comes with the territory of being very smart....

I am starting to cringe. Two threads :w00t:

Run it as a print and please post that.

I think a program could do the job, but not by just installing and click "next". A person that undestands the data and relationships should be able to map fields...

you are welcome and thanks for the update. Glad it worked for you.

I have updated the script with code from Farhan as well.

Glad you saved the bike :P, and heal soon.

I think IT overall is a bit of a frontier. It's maturing, but it's still not as mature as many other industries.

That...

I declared the other variables, and then ran your code and it worked fine.

I suspect you're getting this error on an exec(@sql), correct? Please include the code that's the problem.

Instead...