I'm having an odd issue with SQL Server. What happens is the following:
I create view1. I then create view2 which uses view1. I then create view3 which uses view2.
Then, if I make a change in View1, my other views are messed up. What happens is that columns in view3 (and view2) will be switched. Therefore, if a crystal report for example references view3, I'll suddenly get an exception due to a field in the cyrstal report thinking it's going to get an integer but gets a date instead. It's as if the columns were moved around.
Is this a known issue with SQL Server 2000? Has someone else had that here? Has someone resolved that here?