Switching execution context of whole connection

[Jaheel22]

How to switch the execution context of the whole connection in sql server 2005? I know how to switch execution context to execute certain statments but not sure how to switch it for current whole connection.

Thanks much

 

[mrdenny]

I'm not sure what you mean. A connection to the SQL Sever doens't have an execution context per say.

Are you asking from a .NET point of view?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com