Post reply

Message 7391 error in SQL Server 2000, Windows 2003

  • March 26, 2008 at 1:03 am

    #71292

    Hi,

    SQL

    I have one server 'A'.

    2 databases - 'AA' , 'BB'

    In 'AA' database a procedure will be executed which will connect to database 'BB'. It will take the path and will connect to another database and will get the data from another database into the 'AA' database.

    The problem is whenever the procedure is trying to connect to 'BB' database it is giving the error 7391.

    If the select query is there without begin tran then it connects to the database 'BB' but if it is executed withing BEGIN TRAN then it gives 7391 error .

    Please somebody help.

  • July 3, 2008 at 5:44 am

    #837747

    We hit this exact same problem on existing views that accessed other servers - it started happening after we applied a load of patches on the server. We dug around and found the following article on the Microsoft website: KB 306212. We followed the instructions and the problem was resolved - we didn't even need to reboot the server!:)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply