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,
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.