Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Modified date for Stored Procedures?
- Thread starter jballum
- Start date
Bernadette
MIS
Hi There
If you modify a stored procedure by dropping it and recreating it it modifys the "Create Date". If you just modify the script without dropping it, it doesnt change the date at all. Stored Procedures dont have a modified date property stored anywhere. Hope This Helps
Bernadette
If you modify a stored procedure by dropping it and recreating it it modifys the "Create Date". If you just modify the script without dropping it, it doesnt change the date at all. Stored Procedures dont have a modified date property stored anywhere. Hope This Helps
Bernadette
- Thread starter
- #3
Bernadette,
Thanks, when I make changes to stored procedures I always recreate them with changes for this reason. I was hoping to find out that there is a modified date somewhere as other people at a client location will not follow the same procedure I do when making changes.
JB
Thanks, when I make changes to stored procedures I always recreate them with changes for this reason. I was hoping to find out that there is a modified date somewhere as other people at a client location will not follow the same procedure I do when making changes.
JB
- Status
Similar threads
- Locked
- Question
- Locked
- Question