New answers tagged sql-server-2000
So I finally found the error, and I'll just have to cross my fingers that this was a lone occurance. The view that kept reverting, after a sp_refreshview in SQL2008 r2, was named "qryCreateSnapshot". Then there was another view, a backup of sorts, named "qryCreateSnapshot_Old". The problem was that in the old view, the body was still "CREATE VIEW ...
Top 50 recent answers are included