Views in MS SQL server

I do a little bit of development with Microsoft SQL server and recently I edited a couple of tables and some really weird problems started popping up. A few of the views that were referencing that table weren’t behaving at all, really wierd faults as well. It turns out to fix the drama, you need to open edit the view and resave it, I think the server needs to recompile that particular stored function. I wonder if there is a way to force that.

1,182 thoughts on “Views in MS SQL server

  1. Spot on with this write-up, I absolutely think this web site needs far more attention. I all probably be returning to read through more, thanks for the information!

Leave a Reply

Your email address will not be published. Required fields are marked *