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 |
|
thivya
Starting Member
4 Posts |
 Posted - 2003-11-25 : 21:51:54
|
| HiIs there any query, to find the altered sp's or tables on a particular date? I'm able to get the objects created on a particular date by using the sysobjects crdate column. but I dont find any other column for the last modified date or something like that?plz help me in this |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-11-25 : 22:26:41
|
| NO. Perhaps you should invest in a change control program.DavidM"SQL-3 is an abomination.." |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-25 : 22:26:53
|
| Altered SPs are not recorded - that's one reason why you should never do thisseehttp://www.nigelrivett.net/sqlserverdevelopment.htmlhttp://www.nigelrivett.net/SQLServerReleaseControl.htm==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Alterted SP's list