"Timeout expired" errors

User is getting timeout errors when they try to backup a 2000 database using
a db backup and restore utility I wrote. The problem has just started
occurring w/in the last few days. I'd like to avoid driving to the site,
over 200-miles away, and changing the .ConnectionTimeout and .CommandTimeout
property of the db connection object building another distribution. Is there
a way to accomplish thisi via some "SET" command in Enterprise Mgr.?

TIA

Timeouts occur on the client side, not on the server, so there is no EM
setting.  I hope you enjoy your trip :-)


pe this helps.

Dan Guzman
SQL Server MVP

"PKSpence" < patrick@NOSPAMpkspen
ce.com> wrote in message
news:u673qFGxFHA.3000@TK2MSFTNGP12.phx.gbl...
> User is getting timeout errors when they try to backup a 2000 database
> using a db backup and restore utility I wrote. The problem has just
> started occurring w/in the last few days. I'd like to avoid driving to the
> site, over 200-miles away, and changing the .ConnectionTimeout and
> .CommandTimeout property of the db connection object building another
> distribution. Is there a way to accomplish thisi via some "SET" command in
> Enterprise Mgr.?
>
> TIA
>
>
>

thanks ;o(

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:eBzkJGIxFHA.2252@TK2MSFTNGP09.phx.gbl...
> Timeouts occur on the client side, not on the server, so there is no EM
> setting.  I hope you enjoy your trip :-)
>
>
> pe this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "PKSpence" < patrick@NOSPAMpkspen
ce.com> wrote in message
> news:u673qFGxFHA.3000@TK2MSFTNGP12.phx.gbl... 
>
>