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

I assume you have, but did you CAST both the variables to something?

The code entitles you to some extras from us, but doesn't change the price of the conference. The PASS folks changed the discount from $500 to $400 on July 1...

Apologies. The SET FMTONLY on part was a typo from the previous day.

I don't like to do this in code, but if you must, query the information_Schema.columns view for the table and column.

Can you query sysdatabases? select * from master.dbo.sysdatabases?

I bet id3 = tempdb, which means you can't find those mdf/ldf files. Get them and put them in the proper place to...