Author Archives: Ram - Page 84

Database – why I am untrustworthy??

Database as untrustworthy, meaning that objects in the database cannot access objects in other databases in an impersonated context.

set @sql = 'ALTER DATABASE ' +
QUOTENAME(@db_name) + ' SET
TRUSTWORTHY OFF'
execute( @sql )