navigate the following URL's you will get the answer:

Code:

------

Needed to Set NOCOUNT ON and change

sp_configure "user options", 512

to

sp_configure "user options", 0

URL's:

------

http://support.microsoft.com/kb/195491

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10693.aspx