Post reply

msdb Help

  • September 5, 2001 at 4:08 am

    #63874

    Hi,

    I run a query on SQL SERVER 7.0 (select+inner join+left join) on a couple of tables (one of them has 25 milions tuples) as sp in a job and everytime I run this job I get blocked process in msdb db.

    Any ideas?

    Thanks in advance.

  • September 5, 2001 at 10:01 am

    #418000

    Need to see some of the code for the sp.

    Steve Jones

    steve@dkranch.net

  • September 5, 2001 at 10:32 am

    #418007

    I increased the space allocated to msdb and the locks are gone now...

    Thanks anyway.

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

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