Refer the link below

http://www.sqlpass.org/news/02apr/index.cfm?passnews=KB1

Could you try deleting the records after disabling the FK constraints referring this particular table. This could be an issue if there are lot of referrences to the table from...

Do you have an option to try out the same with an SMTP Mailing Service instead of the POP 3?

I think you are missing out on a "Begin" and "End".

Insensitive cursors are read only. Hence updates to the table needs to be done explicitly using the update statements. Using cursors for updating records in large numbers is not a...

Try the following query. This would work.

begin

Declare @x1 as varchar(5)

Declare @x2 as varchar(5)

set @x1=null

set @x2=null

select *

from

t1

where

isnull(f1,'')=isnull(isnull(@x1, f1),'') and

isnull(f2,'') = isnull(isnull(@x2,f2),'')

end

In a query when you try to...