Just a follow up.

I still don't know what caused some of my linked servers to lock and not others, but I am back up and running.

The only suggestion I...

I have checked sp_who2 and don't have any hung spids.

Good thought, though. I hadn't considered that one. Just not the problem here.

Any other ideas?

Just thought I would update this. The reason that we couldn't find the how the reporting server could be sending a non-existent subscription was that it wasn't. The report had...

I just tried the same test you did, and got similar results. This is not what I saw with the index I had created the started this thread. Something else...

It would give an error, I don't have the exact wording, but it was along the lines of "The item doesn't exist or is not of type index."

That was the first thing I tried, but when you have an index as badly named as that one, it doesn't work. I'm still not certain how it even allowed...

OK, so the rename still was a no go, but with some more tweaking I did get the drop to work. Now I've just got to wait for the...

Not sure this helps but, there is the full code:

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]

ON [dbo].[srvrpf] ([AONROV],[AORCCD],[AOSTA9],[AOCEK6],[AOSVCD])

INCLUDE ([AOCMPY],[AODIVN],[AOFMAJ])

I would say a separate database makes sense.

This is not too different from the standard scenario where you maintain a separate reporting database off of an OLTP system.

I...

All,

Thanks for the responses. I guess I'm going to continue to go with sa for my ownership. I already have way too many accounts to keep track of for people...

I like the strip, but I thought the final frame, though funny, could have been less cliche. As we've all seen, in movies when a computer gets stuck in an...

I agree with Phil. IT too often these days is so concerned with preservation and protection (of data, systems, etc.) that they forget the root reason for their existence, which...

Rule one: Everyone is self-employed.

Most people forget that, except where prohibited by law, companies, in general, can and will terminate anyone at any time with as little notice as legally...

I too think that dual monitors and computers that can run multiple programs has made me more productive. In the same vein, remote desktop and other similar (vnc) programs that...