I have checked over the whole web and couldn't find a solution that seems to work for me.. I have recreated my stored procedure, making sure to have these lines as first lines: SET ANSI_NULLS ON ...

In our database there is a table which is created with ANSI_NULLS OFF. Now we have created a view using this table. And we want to add a clustered index for this view. While creating the clustered...

I don't get the simple boolean algebra on my sql-server. According to msdn, the following statement should return "1", but on my server it returns "0". Can you help me? SET ANSI_NULLS ON SELECT CA...