Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Copy DB Tables from PRod to DEV Expand / Collapse
Author
Message
Posted Wednesday, November 28, 2012 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 7:37 AM
Points: 5, Visits: 29
Have you considered bcp http://msdn.microsoft.com/en-us/library/ms162802.aspx?
Post #1389782
Posted Thursday, November 29, 2012 11:13 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:33 AM
Points: 51, Visits: 198
Sigerson (11/27/2012)
Jeff Moden (11/14/2012)


Did you make sure the linked server is "read only"?



How can you tell whether a Linked Server is read only. I looked for a 'read-only' flag and didn't find it under that name. I am linking a case management system to our main accounting system and I need to *sure* that I won't update accounting. Ever.


By making sure the account used for logging on to the other server only has read permissions.
Post #1390733
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse