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...

Mike,

I'm confused, you asked for all databases, then you say a few. What exactly are you trying to do?

You can also grab the query from sp_helpdb and filter out system...

Lynn Pettis (3/16/2009)

---

But Tom Sawyer got other people to do his work for him WITHOUT insulting and offending people. Obviously, and I may be wrong here, foxjazz must not...

I think THE THREAD has no worries from this one.