Hi,

I have never seen this problem but a quick search on google revealed the following

http://support.microsoft.com/?scid=kb;en-us;Q295378

I hope it solves your problem.

Hi, see http://support.microsoft.com/kb/306457

We had the same problem with jobs stalling and the above solved the problem.

Hi,

Perhaps I should have started a new posting, but since there seemed to be some informed members with respect to worker threads I thought I would ask the question...

Hi,

Can I ask a thread related question? In SQL 2000 we had to change a registry setting to increase the number of worker thread allowed for the SQL Agent as...

Hi,

Just trawling the site looking for another CPU usage issue and came across this thread.

I have a boss who write very clever but very large queries and then pesters the...

Hi,

It would seem the problem is to do with a registry key which is part of a security feature within the operating system. We haven't tested the resolution ourselves yet...

Hi, does anyone know what APP: XS_M7bca83f3) in the Waitresource would mean?

Mmmmmm

I answered 1) because of the trailing comma after the column declaration. What is puzzling me I have just run the code and they both...

Yes it will create a database called GO, but more amazingly you can also create a table called GO on the Database called GO and you call also use,

CREATE DATABASE...

Out of curiosity I have just tested this and when I attempt to update through the view I receive the following error message:-

Server: Msg 4405, Level 16, State 2, Line...

I would have to test this. Certainly in 6.5 only single table updates could be achieved but  I thought that in SQL 2000 you could update mutliple tables through a view...

@@Identity is not a safe option so try SCOPE_IDENTITY( ), see BOL.