Sorry, I'm looking for a "65536" hit on the status column, rather than the status2 column.

Thanks, this helps a lot!

In a perfect world, I would agree with you on this point. However, our site...

Thanks for the recommendation. I ran across "Microsoft SQL Server 2005 Unleashed" too:

http://www.amazon.com/Microsoft-SQL-Server-2005-Unleashed/dp/0672328240/ref=pd_bxgy_b_img_c

It looks useful as well.

I had similar needs a while back, and I couldn't find a way to retrieve the information without first pushing the output into a temporary table with code something like:

   ...

Good point. I had forgotten about the -h-1 parameter for osql.exe.

I found this link (http://www.sqlmonster.com/Uwe/Forum.aspx/ms-sql-server/1763/ISQL-and-OSQL-Output-Lines-Wrapped-Around-at-256-Characters) that says that print always wraps at 256 characters, regardless of the -w parameter setting for osql.exe. This appears to be true. What a dumb default...  ...

Yukon "Lite"  is available for download:

http://www.microsoft.com/sql/express/

Jon

I normally don’t cross post, but I didn’t want my question to get lost in the middle of this thread, and the people who have...

FYI -

We use DNS CNAMEs in order to avoid hardcoding server names.

No, each server has a script of its own. Essentially, each script consists of a series of SQLMAINT.EXE commands. For each server, each job runs in a serial fashion in...

Joe,

The odd thing is that this code has not changed in over a year, and it used to work fine. The overall sizes of the databases are not that much...

By the way, database size does not seem to make a difference. We are getting the same error on the pubs and Northwind databases too.

Jon

My 2 cts...

WARNING: We created a trigger a while back that hits an executable. It has been my experience that such a configuration can generate some really wild debugging...

My 2 cts...

I tend to leave the logins defaulted to the master database because I have had SQL Server upgrades to choke when it found users defaulted anywhere else.

Jon