Revision Dates

[CliveW]

Hi,


Is there anyway in SQL Server that you can see when a stored procedure was modified. I have a stored procedure that was working and now will not just not work.


Thought is might have been a quoted idenitifer problem but the system has not been restarted,

 

[JamesLean]

You can only see when an object was first created, not modified, from the system tables.

As a general point, it's a good idea to use some sort of version control with your sql scripts, like you would with any other development code. It can help in cases like this!

--James