Monday, October 5, 2009
MS Sql Server bug
We ran into an Sql Server bug today that was rather interesting.  We were implementing synonyms across a number of views, tables, and stored procs in a couple of DB's.  Everything was working fine until another team did a deploy and changed the index on a view that was referenced by one of our synonyms.  It turns out that there is a documented bug which requires that any time the DDL has changed on a view that is referenced by a synonym, that synonym looses it's connection to the view.  This includes just updating the index to the view.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment