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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-10 : 09:34:53
|
| ramana writes "we have n number of data bases, developers add new columns with out the notice of dbas. any way out to see the new columns added on that day" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-10 : 09:40:25
|
| without the tool to audit these things you can improvise...write a query that will retrieve the schema of the tables involvedsave this in a table out of reach of your developerswrite the job that will execute this query or encapsulate it in a stored proc, schedule that job to run every day to retrieve infofrom here there are a lot of things to do, you can email yourself for changes made or just query through the tableyou can use information_schema.[object] to simplify things for youHTH--------------------keeping it simple... |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
identifying new columns added in a table