Ah. I thought that might be the case. The corruption's in the system tables in MSDB and checkDB can't repair corruption in the system tables.

I know there's a way to...

Which one? Amazon lists well over 100 books on C# published by Wrox

Why do you recommend it?

Please post your questions in the certification forum.

Put the trace into a job on the prod server. It's not a heavy load providing you're writing to a drive that's separate from the data or log files.

The server-side...

Sorry, I don't understand what you're asking. Could you explain a bit more please?

Can you run a checkDB on it and post the errors you get?

DBCC CHECKDB ('MSDB') WITH NO_Infomsgs

Looks like you're trying to attach a SQL 2005 database to a SQL 2000 instance.

Adventure works is SQL 2005, hence can only be attached to SQL 2005 or higher.

Most likely it will be exactly the same.

A view is just a saved select statement. It doesn't store data at all. When you query a view you are just...

You mean, if you're lucky, your database comes out of suspect mode. Deleting a log file is like playing russian roulette with your database. You are asking for trouble.

See here...

I've worked extensivly with profiler in 2000 and 2005. It doesn't limit column width in either version.

Run the following query (substituting the correct table name) and see what it returns.

SELECT...

Pre SP2 on SQL 2005...

Maybe, maybe not. I think the second parameter is the service name...

If you save the profile trace to a file or table, the entire textdata is saved. If saving to a table, the column gets defined as type Text.

Are you only...

Performancewise, I wouldn't think much, if any. Accuracy wise however... Float's an inaccurate data type and prone to rounding errors. It's not something I'd like to store financial values in.

EXEC xp_servicecontrol 'QueryState', 'SQLServerAgent'

I don't know what permissions are required to run that though. I suspect fairly high.