 | |
Re: Tracking Table/Schema changes ?Sys<what>?
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Tracking Table/Schema changes ?Sys<what>? -
07-03-2003
, 07:35 AM
|
-----Original Message----- There is currently no way to do that natively in sql server other than constant monitoring with tools like profiler. You can use a tool from www.red-gate.com to compare 2 db's and find difference real easy. There is also a free tool from www.lumigent.com that does some tracking of schema changes. -- Andrew J. Kelly SQL Server MVP "glennf" <gfroemming (AT) primewire (DOT) com> wrote in message news:032801c340e4$2b5d93e0$a501280a (AT) phx (DOT) gbl... Probably old news to most of you, but I am new to this DBA role. Trying to identify a way, perhaps through the system tables (sysobjects) to track changes to table definitions <you know how those developers can try to sneak stuff in>. I see crdate, and rfdate fields, but crdate appears to be object creation, not sure if rfdate ever changes. When changes are made through ALTER type statements, theses dates do not change for type "U" objects. I can track stored proc, User Defined Func changes OK, just have not been able to locate a LastModified stamp at the table level. Any suggestions? Glenn Froemming Primewire Inc . |
#2
| |||
| |||
|
|
Thanks. I had heard of the RedGate tool at a local SQLServer user's group meeting. Have you used it? Is it expensive? We have used a high end general 'diff' tool, Araxis. That's pretty nice, but requires scripting everything out to do the compare at a semi smart line by line compare. Each of these methods requires having a baseline db to compare to. What I'm really looking for is change tracking against a specific DB. I am seeing some things suggesting that the SQLServer dev tools may soon be more fully integrated with Visual Source Safe. Do you know, is that part of Yukon? Thanks, Glenn Froemming MCAD -----Original Message----- There is currently no way to do that natively in sql server other than constant monitoring with tools like profiler. You can use a tool from www.red-gate.com to compare 2 db's and find difference real easy. There is also a free tool from www.lumigent.com that does some tracking of schema changes. -- Andrew J. Kelly SQL Server MVP "glennf" <gfroemming (AT) primewire (DOT) com> wrote in message news:032801c340e4$2b5d93e0$a501280a (AT) phx (DOT) gbl... Probably old news to most of you, but I am new to this DBA role. Trying to identify a way, perhaps through the system tables (sysobjects) to track changes to table definitions <you know how those developers can try to sneak stuff in>. I see crdate, and rfdate fields, but crdate appears to be object creation, not sure if rfdate ever changes. When changes are made through ALTER type statements, theses dates do not change for type "U" objects. I can track stored proc, User Defined Func changes OK, just have not been able to locate a LastModified stamp at the table level. Any suggestions? Glenn Froemming Primewire Inc . |
#3
| |||
| |||
|
|
Probably old news to most of you, but I am new to this DBA role. Trying to identify a way, perhaps through the system tables (sysobjects) to track changes to table definitions <you know how those developers can try to sneak stuff in>. I see crdate, and rfdate fields, but crdate appears to be object creation, not sure if rfdate ever changes. When changes are made through ALTER type statements, theses dates do not change for type "U" objects. I can track stored proc, User Defined Func changes OK, just have not been able to locate a LastModified stamp at the table level. Any suggestions? Glenn Froemming Primewire Inc |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.