If there is a dos errorlevel of 0, then the query succeeds. The query in other words returns a 0.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

I like it. Works well, data limited to the connection doing the work.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

No, our search sucks. We're working on it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands.

You can also just run sp_who2 from QA and...

Monitor the service for up and down. I wouldn't monitor other items (CPU, disk wait, etc) unless you can set a limit of of like 3 failures over 15 or...

no. Data is not "archived". You'd have to build your own process for this.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

also http://www.sqlservercentral.com/columnists/rsharma/enterprisevsstandardedition.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Have you run a dbcc checkdb? I'd be curious to see if this shows up there. The latch issue might be fixed with a clustered reindex rebuild of the tables...

There is a minimum size to which you can shrink files, AFAIK, it's about the base level at which it was created. I'm sure you've run the shrink script a...

There is also a script here that can help

http://www.sqlservercentral.com/scripts/contributions/26.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Definitely some network item. The VPNs can be implemented differently and they don't always pass all ports through the tunnel. Are you connecting by IP or name?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of...

Not sure about the plus sign, might be protection against SQL Injection.

Anyway, you need to self join back to the existing table to get the previous row. Now the previous...

AFAIK, There is no limit on SQL Server 2K Enterprise for Memory, limited by the OS. This ref (http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp) shows that it can take up to 64GB of RAM in...

It appears that W2K3, Enterprise has a 32GB RAM limit. Also an 8CPU limit.

W2K, Advanced Server allowed up to an 8 way x 8GB RAM.

References:

http://www.microsoft.com/windows2000/advancedserver/howtobuy/choosing/default.asp

http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server...

We run it on here, but haven't really tested it turned off. Haven't had any issues though.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net