Posted by Erland Sommarskog on 02/28/07 22:18

The Man (LeJon7881@gmail.com) writes:
> How else can i change the time out?

If the time out is the one I think it is, I would not expect that you can.

> I went to the query analyzer to change the time out status...

And you can definitely not change it from Query Analyzer, as this is not
a timeout in SQL Server. It's a timeout in the client, or more precisely
in the client API.

(There are actually a couple of possible timeouts, whereof some are in
SQL Server. However, the one that by far is the most common that people
run into, is the default 30-second timeout in the client API. On the SQL
Server you can run into lock timeouts, but these are not enabled by
default. You can also have timeouts when accessing linked servers. But
I don't get the impression that PaperVision uses linked servers.)

> Also i don't know if this could help me but i was thinking of purging
> the data in my MS SQL server 2000. Do you know how i can go about
> purging this data?

Reducing the amount of data could indeed help, but do that would require
knowledge of the data model, and I almost guaranteed that doing this on
your own is entirely unsupported by PaperVision. If you want to do such a
purge, you need to talk to PaperVision's support.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]