I wouldn't turn it off unless you are pretty sure nothing uses named pipes...

Our entire vendor software uses NAMED PIPES and crashes with TCP/IP when we went live on it...and...

Your not on a cluster node are you ? i had this error when my sql rolled over to its standby and i couldn't edit a job...so i had to...

Thanks for sharing.........

Glad it helped i remembered doing the same thing in SQL 2000 with the same thing so i knew there be something similar in 2005.

Thanks i will try just giving rights to sp_who

Funny i had the same questions asked me yesterday - my reply was no....first you have tested it then it not be signed off and you want to put in...

That allows them to kill of processes...is there a way to just allow lookup only...........and only activity window and only their own......too

What did you use for monitoring packets.........on sql by the way.

Right click the login name nt and see if it not set to disabled.........

Also if that GROUP has many levels i.e

DOMAIN\SALESGROUP

DOMAIN\SALES perhaps SALES id disabled.

Also the database has to be...

does it send mail without the attachment.

It works in transactional if you have the switch on i forget where it is but - in one of the properties it is on by default....

Should work for you....it...

This thread says you can't

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=297149

But found this

1. Select the ID with the select statement

select * from sysmaintplan_plans

2. Replace with the selected ID and run the delete statements

delete from sysmaintplan_log where...

If the application uses IIS WEB Server could have IIS timeout that has been meet that can produce this error .

If using ODBC then could have time out on that...

No problem i just wondered what they were it is key range locks...because i have the auto statistcis sync on ? is that why i see them.

Glad it working now for you...and you figured it out what problem was good find...