April 22, 2009 at 4:40 am
Hi to everyone i am a newbie to ms sql i am creating a stored procedure to retrive data for the logged user pls give me some examples.
Thanx
April 22, 2009 at 6:51 am
What do you mean by "logged user"?
Have you looked up Create Procedure in BOL?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 22, 2009 at 7:05 am
bvinay57 (4/22/2009)
Hi to everyone i am a newbie to ms sql i am creating a stored procedure to retrive data for the logged user pls give me some examples.Thanx
Are you thinking for any log traces for users, simple inserting, deleting or updating ...if so you can do it also with triggers!
I agree with Jack to check BOL for SP and Trigger, first at all!
April 27, 2009 at 12:19 am
Are you asking for the Currently Logged In users in the SQL Server?
see master.dbo.sysprocesses.
If you are willing to store the history of the Logged In Users, Create SP and check the new entry in master.dbo.sysprocesses compare with your own table.
You can also use Prfiler Trace for this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply