Timeline for Finding changes for table-valued function definition on SQL Server
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 9, 2012 at 7:18 | vote | accept | Jama | ||
| Oct 8, 2012 at 19:58 | answer | added | Roi Gavish | timeline score: 0 | |
| S Oct 8, 2012 at 19:06 | history | suggested | András Váczi | CC BY-SA 3.0 |
.language.
|
| Oct 8, 2012 at 18:49 | review | Suggested edits | |||
| S Oct 8, 2012 at 19:06 | |||||
| Oct 8, 2012 at 18:14 | answer | added | Zane | timeline score: 5 | |
| Oct 8, 2012 at 15:02 | comment | added | Aaron Bertrand | You might be able to find the ALTER FUNCTION event in the default trace, but you probably won't still have the original version, so it won't help you. You can also capture these things with a DDL trigger, but you'd have to do that in advance. This is why we take, test & save backups (and also a strong case to consider source control). They're the things you don't think you need until someone screws you over. | |
| Oct 8, 2012 at 14:53 | comment | added | Jama | I didn't have the backup for the version which worked correctly. Is there any tool which shows changes from something like change logs? | |
| Oct 8, 2012 at 14:43 | comment | added | Aaron Bertrand | Do you have a backup of your database? | |
| Oct 8, 2012 at 14:41 | history | asked | Jama | CC BY-SA 3.0 |