April 12, 2011 at 12:39 pm
A logon trigger that records the event to a table should suffice. Dump the ip, hostname, username, event time etc to that table and you would start to get a good idea of how it is being used.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 13, 2011 at 5:57 am
You can also run a server side trace and filter on login, hostname, ip, Program_name. Run that for a week or so to give you a better idea.
April 13, 2011 at 1:49 pm
Change the password and see who screams!:-P Then you can also fix the security holes in those applications. I'm only partly joking.
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 13, 2011 at 2:02 pm
Jack Corbett (4/13/2011)
Change the password and see who screams!:-P Then you can also fix the security holes in those applications. I'm only partly joking.
You're messing me up with that avatar !
April 13, 2011 at 2:13 pm
homebrew01 (4/13/2011)
Jack Corbett (4/13/2011)
Change the password and see who screams!:-P Then you can also fix the security holes in those applications. I'm only partly joking.You're messing me up with that avatar !
He's only 1 of about 8 that are now using it (including Mr. Fritchey).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2011 at 8:50 am
Is this the "Login Auditing" feature that can be enabled from the Server Properties in the Management Studio that you're referring to? Or is this a different method, if so, can you explain how? Thx.
April 14, 2011 at 9:30 am
Here is a technet article on it:
http://technet.microsoft.com/en-us/library/bb326598.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2011 at 10:21 am
Jack Corbett (4/13/2011)
Change the password and see who screams!:-P Then you can also fix the security holes in those applications. I'm only partly joking.
Dont joke like that.... I have done this in the past... and more importantly, I will do it in the future!!! :hehe:
Viewing 8 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply