Please post in the appropriate forum for your version. Moved to ss2k5 as a guess.

Is there something in the error log? Was a maintenance plan run that looked to repair...

I heard this was an Antigen issue that is fixed in SP1. Why it started yesterday, no idea.

I'll check on the RFC compliance. I thought we were. If you have...

Great debate and good to see everyone fired up. Wasn't sure if anyone would like this one 🙂

We all have our own perspective and I'm sure some people conjure up...

As Matt mentioned, there isn't a good way to do this in SQL 2000. There are some complicated queries, but they often don't perform well. A temp table can work...

You are welcome and glad it will help.

One cool thing to think about as well is that clients can actually generate the GUID themselves and insert the values. They're unique,...

Is there something in particular you want to check? The maintenance plan runs as a job, which can be set to alert you on success and/or failure.

Actually you could use log shipping.

What I'd think about doing is restoring the production db, then set up log shipping. You might want to pause the jobs for log shipping...

Actually if you have possible corruption on your system database, I wouldn't mess around. We might get you past it, but something else could happen.

Call PSS and work through this...

As it says, you can force the subscription by passing in a parameter.

Here's the entry in BOL: http://technet.microsoft.com/en-us/library/ms175980.aspx

This is a high end certification, mostly for internal MS people and consultants. Not sure it's worth it unless you plan on being a consultant and billing a high $$/hr...

Monitor meaning record size or alert you if it gets to some size?

You can run perfmon, log the size in a CSV and chart it, load into a table, etc....

That KB shows you how to script out the logins and move them over, with passwords intact.

As Pam mentioned, this won't do anything to them on the principal.

I agree with Greg that this is probably not stored anywhere. If you have logins audited, you could check who logged in at various times.

However if no one will admit...

You can't remove the file without removing all objects from the file.

An output parameter can be used to assign a variable the result of a stored procedure. Less used now that we have user-defined functions.

For dynamic Sql, it's something like

declare @cmd...