If the connection is terminated, then any active transactions that are
occuring inside the stored procedure that have not yet been committed
will be rolled back. Any committed transactions will be preserved. If
you want all work items inside of the stored procedure to be handled
as a single unit of work, you can implement an explicit transaction.
For more information, see "Explicit Transactions" in SQL Server Books
Online.
--Mary
On Wed, 14 Jun 2006 11:53:31 -0700, "Lit" <sql_agentman@xxxxxxxxxxx>
wrote:
Hello,
The default ADO.NET Timeout is 30 seconds.
If I execute a Stored procedure that takes lets say 120 seconds then what
happens.
ADO.NET Times and throws an exception
But what about SQL Server Does SQL Server keep on Executing the Stored
procedure?
RE: exec sp_help_job user account rights ... wrapper in which u can call original stored procedure sp_help_job using “WITH ...EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ... (microsoft.public.sqlserver.security)
Re: Problem with the Legacy ASP files and the Sql Server Express ... It looks like it is not going to be an easy job getting it to work on the SQL Server 2005 and Express:(. ... 'Then you can execute the command and then retrieve the ID ... I am 100% sure this code works against any version of SQL Server, as long as the connection is OK and the SP has two parameters @varCompany as Input and @Return_Value as Output. ... I do not think your problem is due to difference of SQL Server2000 and SQL Server2005, unless your stored procedure has some thing that only works in SQL Server2000, not SQL Server 2005. ... (microsoft.public.dotnet.framework.aspnet)
Re: How to get list of EventClasses in MSSQLServer2000 ... statement inside a stored procedure has completed.') ...SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ...Login','Occurs when a SQL Server login is added or removed; ... (microsoft.public.sqlserver.security)
RE: exec sp_help_job user account rights ... I don’t know whether it work or not, but u can create a stored procedure...EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ... (microsoft.public.sqlserver.security)
Re: Stored Procedure Security/Permissions ... Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 ... > permission to read either table; ... > permission to execute the stored procedure, ... (microsoft.public.sqlserver.security)
