Enterprise manager timeout  
Author Message
DarenF





PostPosted: Wed Oct 25 08:18:54 CDT 2006 Top

SQL Server Developer >> Enterprise manager timeout

Hi all
I run a sp with enterprise manager but it gives me timeout error on 30
seconds.
I changed the Query Timeout in Options menu to 0 (unlimited).
but it still occurs on 30 seconds.

thanks in advance

SQL Server135  
 
 
Tracy





PostPosted: Wed Oct 25 08:18:54 CDT 2006 Top

SQL Server Developer >> Enterprise manager timeout
> Hi all
> I run a sp with enterprise manager but it gives me timeout error on 30
> seconds.
> I changed the Query Timeout in Options menu to 0 (unlimited).
> but it still occurs on 30 seconds.
>
> thanks in advance
>
>

Don't use Enterprise Manager to run queries or manipulate data, it's not
intended for such use. Instead, use Query Analyzer...

--
Tracy McKibben
MCDBA
http://www.realsqlguy.com