Okay now I am asking this because no one in the building has a clue. I have a stored proceedure that connects to another database using OPENDATASOURCE. Now it had been working for 5 months and all of the sudden stopped. Now it is showing the following: Server: Msg 18, Level 16, State 1, Line 1 Now I checked with the Firewall people and they did not chop off the ports like they did to me in the past. The same query can run from my development box with no problems. Msg 18 mean nothing, the logs in both database boxes says nothing! I have no clue what is going on! Once in awhil I get a message that says access denied. The user name and password have not changed. If anyone has any opinions on what could be wrong (I know do not use a MS product) please state your mind! Eric
Well there seems to be no Msg 18 at all at MSDN web site. However, even though it was a different message number, is it possible the database, data, or index has been corrupted. That could be a good explaination, but a guess on my part. Mark