SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
my execution timeout is always show 90, but i need to set it 0
Programming language used to interact with SQL Server databases
This cannot be done from TSQL.
To fix it from SSMS tool:
You cannot set that timeout from T-SQL, as this is a client-side setting over which SQL Server has zero control.
Exactly how you set the timeout depends on the API you are using. For instance, in .Net it is a property on the SqlCommand object.