---

Development Category

Alias in View Bug in Microsoft SQL Server Management Studio

Posted: Wednesday 10 May 2006 @ 2:47 pm by joecm

I knew I should have waited for SP3, but SSMS has a much nicer tabbed interface. It integrates Enterprise Manager and Query Analyzer into one place and in general improves my productivity. But it clearly should still be in beta. I’ve had a number of problems with DTS which I won’t go into now, but I just ran across a crazy bug.

I have a SQL Server 2000 database that has 4 tables and a view. We recently had to add a column to one of the tables. Simple right? I used SSMS and added a varchar(10) to the end of the table. When I went to test the results, my app started spitting out all kinds of jumbled data. Huh? What the hell is going on? I only added a column.

I soon traced it to the view and I was suprised at what I had found.