I have a hunch that the source of the trouble is related to the fact that my view uses tables on two linked servers. The servers are set up with Ansi_nulls and Ansi_warnings on. In my script I connected only to the server with the view definition. Any thoughts. Thanks.