Just one side comment Steve. Althought it is nice to put a face to the name, I suggest that you go back to the pictures of Everyday Jones. ...

CU6. Apparently whomever got assigned to my case was less than compentant. I re-submitted my request, and got the correct build.

But I agree that having TESTED service...

Has anyone tried to get a copy of it? I am on my third attempt. First response was this is included in SP2. 🙂 Second was...

It was part...

auaiomrn (2/12/2008)

---

I did just finish running dbcc checkdb on a copy of the database from before the "fix", and I got a whole bunch of "Missing or invalid key in...

The OP stated that it was part of the PK (Nulls not allowed).

Actually...

Understood 🙂 LOL, best of luck.

Tom Leykis (2/4/2008)

---

This is how I've always done it in the past:

while @count < 10

begin

select @count = @count + 1

...

This is the best answer I have found on the subject.

http://www.sommarskog.se/share_data.html

Of that the most generic method was the following.

sp_addlinkedserver @server = 'LOCALSERVER', @srvproduct = '',

...

This really sounds like a blocking issue. I read through all the threads, but don't recall you saying if you checked for locks (on the process), not just the...

Pam,

That is the question we should be asking! Why is your system doing so much ddl that you are creating contention on the system metadata? Sounds like an...

In a normal environment where dropping and creating of table (except for temp tables) was a rare occurrence, I would agree. But in this case the OP is stating...

You aren't suggesting that it...

Not that it is significant in this case, but a very minor change will improve the performance.

IF EXISTS (

SELECT 1 from syscolumns WHERE ID = object_id('DcReservationContact') and name =...

On 3/1/2007 I started the job I am in right now.

Before I started here the only SQL Server I had used was the express edition and I only knew that...