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.
| Author |
Topic |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-02-11 : 03:02:51
|
| i alter the existing store procedure.add few lines in this procedure andrun the procedure it shows Command(s) completed successfully.and procedure also was altered,but after few minutes this procedure gone to old state,altered informations are gone.we altered more than times but same problems occurred.no about details in server trace files.no scheduled jobs running in these hours.what is the problem?if any setting changes in SSMS--Ragu ThangavelJunier Sql Server DBA |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-11 : 04:00:24
|
| Has the database been restore in the mean time? Any database triggers present? Maybe some security auditing is running somewhere...? It sounds odd though.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-02-11 : 04:08:06
|
how do you alter the stored procedure ?any chance you have a "begin trans" before you alter the stored procedure and changes got rollback ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-11 : 06:04:48
|
| Create a database audit on the SP to find what exactly in happening.PBUH |
|
|
|
|
|
|
alter store procedure