Re: Is it possible to create a custom SQL session function/variable
- From: "Adam Machanic" <amachanic@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Jun 2007 00:07:10 -0400
Asked and answered in .programming. Please refrain from multiposting.
--
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"GMG" <gmgsoftware@xxxxxxxxxxxxx> wrote in message news:%23cNc2ceuHHA.3376@xxxxxxxxxxxxxxxxxxxxxxx
To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @@SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?
.
- References:
- Prev by Date: Re: Permission problems user can't create a table
- Next by Date: Complete Neophyte Question(s)
- Previous by thread: Is it possible to create a custom SQL session function/variable
- Next by thread: Complete Neophyte Question(s)
- Index(es):
Relevant Pages
|
|
