Well not everyone will agree with me but you have to after referring to David LeBlanc's blog . Refer to BOL entry on impersonation , implementing impersonation in ASP.NET application on this KBA .
Read More...
This was the question raised by a newbie DBA at my workplace! Endpoint in generic network terms they are the objects that represent a communication point between the server and client. In SQL Server as per the Authentication mode (Windows only & mixed)
Read More...