How to install CommandTimeout

Question

I am using Microsoft.SqlServer.Management.Smo .

My code is:

 Server server = new Server(new ServerConnection( new SqlConnection(ConnectionString)); server.ConnectionContext.ExecuteNonQuery(script); 

I want to set CommandTimeout for it, as is the case with regular SQLCommand

Please tell me how to set CommandTimeout for queries passing through Microsoft.SqlServer.Management.Smo.Server

Answer 1

Try server.ConnectionContext.StatementTimeout

Answer 2

You can set the command timeout using the SMO object, as shown below:

 Server server = new Server(new ServerConnection(new SqlConnection(ConnectionString)); server.ConnectionContext.StatementTimeout = 10800; server.ConnectionContext.ExecuteNonQuery(script); 

For more information about the SMO object command timeout, see this link .

Answer 3

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx

how to set query timeout from SQL connection string