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 - 2003-04-09 : 07:39:34
|
| Simona writes "Hi there!I've looked in SQL Books and all over the Internet, digged through your web site (which is a very good friend of mine being very useful) but I didn't found the answer.So, how can you get the last date&time when a table design was modified, not when data from a table was last modified. I needed for an admin tool which coudl give me a quicker vewi when comapring two environments where the changes happened.Thank you very,very much.Kindest regards, Simona" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-04-09 : 07:59:05
|
| There's nothing like that built in.You should...(a) create a 'change control' process whereby your ddl admin's document changes, and(b) hire dba's that you trust to follow the procedure.Jay White{0} |
 |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-04-09 : 08:27:54
|
hth,as already told by page there is no such way to control ddl changes to a table desgin.. if u wanna to control the changes to table design u can implement Visual Source Safe. It gives better version control with appropriate time of change done.. but i understand & fear thatz applicable to stored procedures  .RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
Last Modified for a table/database