Gremlins.........

Seriously though, data modification is the only way the indexes can get out of whack like that.  Just for SAGs, if the fill factor is at 100% change it to...

I think you're going to have to do the check for the value prior to each individual insert.

Mark

I wish I had some real experience in this subject, so what follows is purely speculation on my part.  I'm sure the global sports such as Cricket and Formula One...

Look at your syntax after q$, you have two slashes. \\

Also, you may have to enclose the folder name in either brackets or double quotes when they have spaces in...

I had to do this once to a vendor database.  What I did was confer with the vendor and got an approval to add Identity columns to the tables that...

I see one thing that may not be right; check this out from BOL:

@message_id = ] message_id

Is the message error number that defines the alert. (It usually corresponds to...

1) I haven't experienced too many problems, if any, running SQL Mail on SQL Server 2000.

2) Are your SQL Servers clustered?  If not, then no warnings.  If they are, you...

Check out Embarcadero's Change Manager, maybe that will do what you need.

Mark

Are the .ldf files in the same directory folder as the .mdf files? If so, move the .ldf files to a different drive and folder.

Is it possible the user is part of the db_datareader group for this database? Or, is in a role that has been granted SELECT permission on the table?

Mark

I have a question for you, inside the SP call, is there a BEGIN TRAN statement?

Mark

I can't recreate the problem; while connected to a server from my desktop I get results back. Are you sure your database is Master when you're connected from your...

Not sure what your concern is but it's not a problem to change it, go for it.

Mark

To piggy back onto Todd's suggestion, check out the Execution Plan and I'll bet the table scan will stand out like a sore thumb.

Mark

From a purely best practices point of view, pick one and ask the the team to stick with it. That way everybody gets used to reading and coding the...