Sounds like an install issue. I'd uninstall the tools and reinstall them.

A service pack includes all previous cumulative updates. At any time after RTM you can upgrade to SP3.

We maintain a build list here as well: http://www.sqlservercentral.com/articles/Administration/2960/

The CUs are not tested...

What access do they need? Just viewing table data in grid form?

I might start there and look to grant them access and let them use Excel or Access to query...

If you add a file to the primary, I think this gets pushed across to the mirror as the same command, meaning same paths. If you need that changed, you'd...

Added my vote as well.

I'd be happy with xp_readerrorlog being documented as well.

There were more proxies in 2005, but they existed in 2000.

http://msdn.microsoft.com/en-us/library/aa260700(SQL.80).aspx

If it's not deleting, that leads me to believe there might be a bug here with the account. You can...

I like ALZDBA's suggestion, and hadn't thought of that. It adds an extra step to backing up and restoring the db, but that might be a good way to track...

Do you have more than one filegroup? I've seen this before when someone has a second one and it is not set as the default.

When you say it goes away, do you mean you

- get error in the log

- run DBCC and there are no errors?

- reboot

- get the error again?

Typically these errors are...

My guess is that vendors are just behind getting something done. I've seen this before with other exams, often because there weren't enough authors interested, or they were busy on...

There is no risk of changing data in a hot backup in SQL Server. The log records are used to ensure this is completely safe.

I'd second Lowell's advice here. Don't really know of a better way.

I'm sure someone will appreciate your update.

Thanks for the info.

I agree with Barry that it's pretty easy to implement, but it can be complex to understand and keep it straight in your head which rows are visible to which...

Hey! I know I'm not the most...