How to set CommandTimeout

Question

I am using Microsoft.SqlServer.Management.Smo.

My Code:

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

I want to set CommandTimeout for it like we do with normal SQLCommand

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

Rajesh · Accepted Answer · 2012-05-09 09:44:23Z

10

Try server.ConnectionContext.StatementTimeout

edited May 9, 2012 at 9:44

Rajesh

7,9066 gold badges25 silver badges37 bronze badges

answered May 9, 2012 at 8:00

Strillo

2,98215 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajesh · Accepted Answer · 2012-05-09 09:46:21Z

8

You can set 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 on SMO object command timeout refer this link.

answered May 9, 2012 at 9:46

Rajesh

7,9066 gold badges25 silver badges37 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:22:40Z

1

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

how to set the query timeout from SQL connection string

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered May 9, 2012 at 7:56

Tilak

30.8k19 gold badges85 silver badges133 bronze badges

2 Comments

Dr. Rajesh Rolen Over a year ago

i know how to set commandtimeout with sqlcommand.. but i don't know how to assign that command to Microsoft.SqlServer.Management.Smo.Server

Tilak Over a year ago

did you try to set ConnectTimeOut in ServerConnection, msdn.microsoft.com/en-us/library/…

Collectives™ on Stack Overflow

How to set CommandTimeout

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related