Inside a stored procedure, I have the following : ( sql server 2008 )
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRANSACTION getStuff
/* some selects, updates, etc, etc. */
COMMIT TRANSACTION getStuff
Since this is transaction based, my thought was the rest of the database connections will not be affected by the SERIALIZABLE.
Do I need to implicitly set isolation level to read committed after my commit? Will this adversely effect other connections between my application server and database server?