All pastes #177570 Raw Edit

Stuff

public text v1 · immutable
#177570 ·published 2006-09-20 14:51 UTC
rendered paste body
[17:39] <daniela--> I modified a view in SQL Server 2005 to forget about 3 oarameters (ImageName, ModelID, ModelName), i pressed the Execute button,  but it seems that the modifications were not applied
[17:40] <daniela--> I'll show you a picture, watch how in the treview the 3 parameters are still  there in the Columns node, but in the right window look at the source of the View 
[17:40] * wasabi_ (~wasabi@207.55.180.150) has joined #sql
[17:40] <daniela--> http://img73.imageshack.us/my.php?image=viewcq6.jpg
[17:41] <daniela--> I keep getting errors cause somehow  my modifications are not entirely applied 
[17:41] <daniela--> (or are not applied at all)
[17:42] * dfworking (~uh-huh@IGLD-80-230-82-35.inter.net.il) has joined #sql
[17:44] <daniela--> select * from that view generates these errors: http://pastebin.ca/177562
[17:46] <daniela--> help?
[17:48] <daniela--> hmm, I expressed myself wrongly, they are not parameters, but 3 columns that I;m not interested in selecting anymore