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.
| Author |
Topic |
|
josh2009
Yak Posting Veteran
81 Posts |
 Posted - 2010-06-03 : 16:46:10
|
| Hi,Is there a way for me to find out or track actions done in Management Studio 2005? I have a stored proc that has been in production for a month now and all of a sudden, my user complains that something was not working right related to the stored proc. Upon investigation, it turns out my stored proc was missing and was wondering if there was a way for me figure out what happened to it. Any help will be greatly appreciated.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-06-05 : 06:52:19
|
| you've to run a trace in your db to get this info.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
dattatreysindol
Starting Member
20 Posts |
Posted - 2010-06-07 : 02:23:41
|
| Hi There - There is a concept of Auditing in SQL Server which can be used to identify the activities on a server including DDL activities.Check out the following links:http://www.mssqltips.com/tip.asp?tip=1006http://msdn.microsoft.com/en-us/ms189540(SQL.90).aspxHope that helps!Dattatrey Sindolhttp://mytechnobook.blogspot.com/This information is provided "AS IS" with no warranties, and confers no rights. |
|
|
|
|
|
|
Tracking Stored Procs