I'd detach, then rename and attach as you mentioned. Not sure if there's an easier way. Don't forget this is a fairly big change. All connection string code needs to...

Good idea, I'll tackle it today.

great questions. Ones I han't thought of. I'll ping Andy for some clarification.

There might be, but how do your determine a 4 column table has columns 1,2,4,5 and not 1,2,3,4? If you can explain that logic, I'm sure someone can generate some...

The permissions to start SQL Server should come from the Windows service permissions. Stopping can come frmo SQL Server or Windows, depending on whether you can issue a stop command...

Wow, you guys are tough. This was submitted and I suspect my poor check box marking skills resulted in the wrong answer be listed as correct.

Thanks for this. Along those lines, database backups don't truncate or clear the log, so you need to be sure you add those in as well if you are not...

bcp out some sample rows/tables, load into Word, Tools |+ Word Count

The multiple out for an estimate. Believe me, no one is...

Doesn't happen to me. 3 different XP machines. Perhaps did you log in with a different profile?

Not sure that's a valid date. I typically use 1/1/1900 or some other trigger date to mark invalid dates. Can you search and replace in the text file?

Use a simple Data Transform to import the file from text to a SQL table using DTS. Then use T-SQL to clear the data.

update sql.equiptable set status_code = 0, space,...

I very, very rarely had anything every come up in checkdb, so I tend to run is weekly. That being said, if you can, as Alan mentioned, nightly before backups...

osql /? will give you help. /E is for trusted connections using Windows auth.

Apologies! The answer has been corrected and the points awarded back. The question was submitted by a user and I was in a rush and didn't double check it.

At this point I think you want to uninstall, reinstall SQL. Then you can move the master and other databases to where you need them.

As far as moving:

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp