December 5, 2008 at 12:09 pm
Didn't figour out how to check the value of database property TRUSTWORTHY ? Anyone could light me up ? Thx.
ddfg
December 5, 2008 at 1:50 pm
i dont know T-SQL command for that.... in SSMS
1) right click on database you want to look on
2) select options and look for trustworthy in the list of DB options...
December 6, 2008 at 6:23 pm
select name,is_trustworthy_on from sys.databases
MJ
December 7, 2008 at 11:20 pm
Dear
Thanx for reply,What is meaning of trustworthy databases...
Thanks
December 8, 2008 at 12:07 am
check this:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/64b2a53d-4416-4a19-acc0-664a61b45348.htm
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2020 at 3:07 pm
SELECT [name], is_trustworthy_on
FROM master.sys.databases
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply