t-sql checks - SQL Server Forums

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 2008 Forums

Transact-SQL (2008)

t-sql checks

Author

Topic

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2011-03-01 : 17:44:05

I would like to know the following:

1. What t-sql can I use to see if a stored procedure has changed? I want to see the last modified date? Would I look

at sysobjects?

2. What t-sql would I use to see if a view and function changed. I would like to see the last modified date? Would I

look at sysview?

X002548
Not Just a Number

15586 Posts

Posted - 2011-03-01 : 17:57:53

I gotta look, but they didn't have a modified date...maybe 2008 aded that column when you use ALTER

However, I mainly use DROP and CREATE as my method

So if you do this, then you will never know.

Look at the system tables in Books online

But again, it depends on how you (or your developers) make sproc or view modifications

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

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-03-02 : 01:31:02

Kindly follow the original thread... This will help us both!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=157592

Cheers
MIK

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources