Old Pedant,

I think it's more of them saying - What did you (me) do to it. I think they know I touched the wrong "button" and I broke it. The server is hosted some where else, but I have total control over the server. I can actually hurt myself all on my own :-)). The @@servername doesn't match my actual machine name/computer name. From what I've been reading, @@servername should match because it is what defines my local server to everyone connecting to the SQL server.

Does that make sense? I think I need to do a sp_dropserver to get rid of the server name that doesn't match, followed by an sp_addserver to change the name of my localserver to what does match my physical computer name.

Thanks again for your help.

Radfo

It looks like I've fixed my problem. My local server name was incorrect for some reason. I ran the sp_dropserver to drop the local server that was registered and then I ran the sp_addserver to add the correct local server and it started working. I discovered this when I selected serverproperty("servername") with @@servername and saw that the two didn't match. The @@servername showed the incorrect servername. I hope this helps someone else.

Thanks for the help and ideas Old Pedant.

Radfo

Thanks for telling us how you solved it! Not at all obvious and something I'll stick away in my memory banks for possible later needs.