October 5, 2010 at 10:26 am
Hello,
I have this one account xxxxxx used in applications to access the sql production data, this account information is known to the developers, I notice couple of developers use that account to login to SQL Management Studio to connect to Production Servers to run the queries and other heavy tasks which they are not suppose to,
Is there any way I can monitor that,
Help is highly appreciated,
Dev
October 5, 2010 at 1:53 pm
Run the profiler probably from the remote machine, Filter by the User account and check the application name and host name.
Check if the host name is not equal to the application server, then you got the culprit.
Thank You,
Best Regards,
SQLBuddy
October 5, 2010 at 11:35 pm
Try running a Server Side trace with all the filters mentioned above. Running a profiler trace on a production instance might have negative impacts. An example here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 5, 2010 at 11:58 pm
Login trigger? If you want to monitor their logins not what they do afterwards. You can also prevent those logins with an appropriate login trigger.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply