Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Get LoginID

Author  Topic 

geossl
Yak Posting Veteran

85 Posts

Posted - 2003-12-15 : 01:42:48
Dear All,
How to get the loginID of the current user as I would like to check it in the stored procedure.

Thanks.

Geo

nr
SQLTeam MVY

12543 Posts

Posted - 2003-12-15 : 05:20:46
Try user_name(), system_user.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -