The title says it all.
views:
274answers:
2
+1
Q:
How to tell using T-SQL whether a SQL server database has the TRUSTWORTHY property set to on or off
+2
A:
In SSMS:
Right click over the database, Properties, Options last record under Miscellaneous
In T-SQL:
select is_trustworthy_on from sys.databases where name = 'dbname'
Vinko Vrsalovic
2008-09-24 08:19:39
Perfect: Thank-you
2008-09-24 10:12:11