Modified time of Stored Procedure

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Modified time of Stored Procedure

Author

Topic

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2007-03-27 : 06:21:40

Hi frns,

How to know at what time a stored procedure got modified using Alter procedure ....

I have seen in the Enterprise Manager but i am able to get only Created date.

Regards,
Franky

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-27 : 06:26:37

Enterprise Manager ? Are you using SQL 2005 or 2000 ?

in 2005


select 	modify_date
from 	sys.procedures
where	name	= '<stored procedure name>'

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-27 : 06:56:22

In SQL 2000, your only option to keep track of this is through version-control system.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

pootle_flump

1064 Posts

Posted - 2007-03-27 : 08:07:32

Or (in 2000) you can use DROP\ CREATE instead of ALTER and interpret the creation date as the modification date.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-27 : 08:09:28

quote:
Originally posted by pootle_flump

Or (in 2000) you can use DROP\ CREATE instead of ALTER and interpret the creation date as the modification date.

Then how you will track earlier creation date?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-27 : 10:41:35

quote:
Originally posted by harsh_athalye

quote:
Originally posted by pootle_flump

Or (in 2000) you can use DROP\ CREATE instead of ALTER and interpret the creation date as the modification date.

Then how you will track earlier creation date?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

You can't...but why would you care? I always DROP and CREATE

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-27 : 10:45:13

quote:
Originally posted by X002548

quote:
Originally posted by harsh_athalye

quote:
Originally posted by pootle_flump

Or (in 2000) you can use DROP\ CREATE instead of ALTER and interpret the creation date as the modification date.

Then how you will track earlier creation date?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

You can't...but why would you care? I always DROP and CREATE

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Because that is what OP wants...he is not using DROP..CREATE version to modify proc.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

pootle_flump

1064 Posts

Posted - 2007-03-28 : 08:50:28

quote:
Originally posted by harsh_athalyeBecause that is what OP wants...he is not using DROP..CREATE version to modify proc.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Perhaps the impossible is the untried?

The OP may have a requirement to use ALTER syntax or (s)he may not. DROP...CREATE is far from ideal but IMHO just slightly preferable to not having a modified date. YMMV. Unfortuntaley methods both can be bypassed anyway.

Of course another option is upgrade to 2005 and then you get both

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources