The above sp is working fine in ms sql 2000 but behaves different in ms sql 2005.

i am getting the unexpected result set in case of ms sql 2005.

But...

hi,

i am not getting any error message.

But the result was not proper.

Hi,

i could not able to open the link which u sent.

How can i change and handle the Null Values in MS SQL Server 2005 if

SET ANSI_NULLS ON?

There is...

i just took the query from SQL 2000 and executed in SQL 2005.

Will it have any impact or lose of any datas becuase of this warning message.

Thanks....After setting the user in the database it worked.