Post reply

Check the setting for trustworthy

  • March 1, 2010 at 11:47 am

    #230439

    I'm looking for a simple select statement off a dmv or something that will tell me the state of the TRUSTWORTHY setting.

    I'm working in service broker and do not want to obtain an exclusive lock on the db if I don't have to. So I'd like to check the state of this setting.

    Any ideas how?

    Thanks!

  • March 1, 2010 at 11:53 am

    #1126622

    This:

    select name, is_trustworthy_on from sys.databases

  • March 1, 2010 at 11:58 am

    #1126627

    Good thing it wasn't a snake... 🙂

    Thank you very much!!

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

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