Estimate the Time for SQL query Execution

Is there any way to estimate the time required to execute a T-SQL statement?
I need to set the command time out by calculating the time for T-SQL
statement. Can any one give an example?


.

Relevant Pages

  • Re: sql data to xml file
    ... You can use sp_OACreate to create objects of FileSystemObject and call its ... but you should be a member of sysadmin role to execute this extended ... > i want for the results of the above t-sql statement to be saved to a file. ...
    (microsoft.public.sqlserver.xml)
  • Re: Estimate the Time for SQL query Execution
    ... In message, Saradhi writes ... I need to set the command time out by calculating the time for T-SQL statement. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: FTPing and Calling an EXE from a SQL Statement
    ... T-SQL statement and you would like to know whether it is possible for you ... to execute exe file directly from T-SQL statement. ... exec master..xp_cmdshell 'echo >>c:\ftp.input' ... you could use xp_cmdshell to execute the exe ...
    (microsoft.public.sqlserver.programming)
  • sql data to xml file
    ... i want to execute the following t-sql statement: ... select * from customers for xml auto, ... i want for the results of the above t-sql statement to be saved to a file. ...
    (microsoft.public.sqlserver.xml)