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
 General SQL Server Forums
 New to SQL Server Programming
 Tracking changes and Monitoring Tools

Author  Topic 

avmreddy17
Posting Yak Master

180 Posts

Posted - 2007-08-19 : 11:18:12
I want to integrate my Production SQL boxes to Visual Source safe.
Can you please guide me on this also if there is any Alternative to
track the chnages in the stored Procs?

How is SQL SPOT LIGHT from Quest as a monitoring tools?.
Or
Can you please suggest me any other tools which are good for monitoring SQL Servers.

Thx
Venu

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-19 : 11:26:40
you can only put script files in the source safe. you can't integrate your prod sql with it.

if you're using sql server 2005 you can see objects last modified date in sys.objects
no idea on sql spot light.

2005 has an extensive monitoring capabilities with Dynamic Management Views and Functions.
look into those.


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-19 : 16:53:05
Idera has sql tools as well.
Go to Top of Page
   

- Advertisement -