• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

Source database must be marked as trustworthy

Hello experts, as I can do this?
Source database must be marked as trustworthy
I tried in the database adventure works but this disable
trustworthy.JPG
0
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
Om PrakashCommented:
You can do this by setting the TRUSTWORTHY property to ON for the database.

Please check the following:
http://technet.microsoft.com/en-us/library/ms188304.aspx
0
 
enrique_aeoAuthor Commented:
i heve thi error
TRUSTWORTHY on;
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'on'.
0
 
marat-ozCommented:
ALTER DATABASE my_database SET TRUSTWORTHY ON
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now