"Casino's (sic) do not sell fun; they sell a way to get you to give up your money under the pretense you can live your life with 24 hours a day...

Casinos profile for cheats. Ask any pit boss or manager. Your dress, attitude, behavior at the tables, how frequently you move from game to game, how you interact with other...

We document new features and fixes before we write code, and our documentation must include a testing plan for the feature or fix. When the...

Possibly dumb question: Are users updating the table while you are switching between QA and EM, running queries, refreshing, etc?

Check out this link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;229564

Are you using the Named Pipes Net-Library to connect to the SQL Server database? If so, try using the TCP/IP Net-library instead.

You don't mention which version of SQL server...

...Hmmm. Went to "spaces", and noticed that Mr. Thacker proudly uploaded 169 pix from his visit to...Madame Tussaud's Wax Museum(!)  Irony, anyone?

PS. Buy Ken's book. You won't be sorry.

A tuple is a data object containing two or more components. It seems to me you could argue any of the possible answers would be correct, because 'Tuple' is so...

Also from BOL:

Examples

This example makes the user Albert the owner of the current database and maps existing aliases to the old database owner to Albert.

EXEC sp_changedbowner 'Albert'

"HOLAP" - -

Hm.     Sounds like a disease you might get after visiting a "gentlemen's club"

FWIW: I played around with this. Appears that a string of spaces will also convert, not just empty string.

DECLARE @myID int

SET @myID = '                              '   -- 30 spaces

print @myID

Returns 0

for performance purposes, how about this tweak:

set rowcount 1000
while exists(select top 1 * from orders(nolock) where fulfilled <> 1 and status=1)
begin
  update orders
    set fulfilled =...

Did you include SET ANSI_Warnings OFF within the procedure itself?

IHTH,

b