X xxxxyz Mar 21, 2005 #1 Can I get user id from sysusers table in my C# code when the user is connected to the database? Thanks.
Can I get user id from sysusers table in my C# code when the user is connected to the database? Thanks.
M marc.derider Mar 21, 2005 #2 sp_helplogins will retrieve a list of all Logins for the SQL Server. the Colum SID will be returned as a byte[]
sp_helplogins will retrieve a list of all Logins for the SQL Server. the Colum SID will be returned as a byte[]
M Marc Scheuner [MVP ADSI] Mar 22, 2005 #3 Can I get user id from sysusers table in my C# code when the user is connected to the database? Click to expand... Just create a SqlCommand with the query text select uid, name from sysusers and execute that - that's all there is, really. Marc ================================================================ Marc Scheuner May The Source Be With You! Berne, Switzerland m.scheuner -at- inova.ch
Can I get user id from sysusers table in my C# code when the user is connected to the database? Click to expand... Just create a SqlCommand with the query text select uid, name from sysusers and execute that - that's all there is, really. Marc ================================================================ Marc Scheuner May The Source Be With You! Berne, Switzerland m.scheuner -at- inova.ch
