Well I guess I am having a conversation with myself

Here is an update for what it's worth.  I restarted the IIS services and...

False alarm. I added warnings off and it worked, but now it stopped working again.  It just keeps getting weirder and weirder. 

Im stumped.

EUREKA!!

Remembering the last time I felt this frustrated lead me to the problem. 

SET ANSI_WARNINGS OFF

I assume that at some point in the past I had turned ANSI warning off in the...

Oh ya, It is important to add that 4 or 5 ASP pages that retrieve "FOR XML" data from sql all broke at the same time. So that would strongly...

Sounds like your having the same problem I was but from a different source.  Fortunetly we had other reasons to install sql2000 on the same box so the natural solution...

Thanks.  I needed specifically to connect to the database from a remote server and I foudn the answer. Sharepoint services installs a version of MSDE called WMSDE which specifically forbids...

My bad, guess it was a late night and when I rebuilt the table I didn't add the primary key back in...duh!

is much faster...

Thanks I appriciate your help. The Tables have a very basic structure:

Vendors

uid  INT ident

vendorName varchar(100)

Messages

email varchar(100)

phone varchar(50)

message varchar(2000)

===

As a note: I am updating the message posting section of the site...

So I generate the new GUID first, add it to my insert and return it to the calling proc. Ya that would work.

Thanks loads

Well have been mostly using session variables (IIS6) to store the id of any currently logged in user. Then lets say I pass the user a list of some objects...

Thanks, cmd.ActiveConnection.Errors(0).NativeError is going to help.

Perhaps a firewall was updated somewhere else on your network?  Can you port scan your server from another machine and see how it responds.

When you say you are supporting this application, do you mean that if something happens to the db or server it's your head?   If so then don't pussy foot around,...

Doesn't SA also operate in the same security context as the account used to run sql?  Potentialy widening the risk to the entire server?

So the intruder could use xp_cmdshell to...

Well what a coincidence. I just read about this on MSDN and was logging in to post a question about it and lo-n-behold it's the QoD!!

I think the QoD answered...