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

retrieve database information from the server having only read-only permissions Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 12:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:57 PM
Points: 31, Visits: 52

Please help me on the below question . I faced this question in an interview.

How to retrieve database information from the server having only read-only permissions and move it to another server?
Post #1477869
Posted Friday, July 26, 2013 3:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 277, Visits: 838
What information are you after? And do you mean from the SQL instance or the server registry?
Post #1477912
Posted Friday, July 26, 2013 6:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:57 PM
Points: 31, Visits: 52
Dear Sir,

I want to take the complete database instance (including tables and its information) and move to into another
SQL server machine.So in the destination SQL server machine any user can see the records.
Post #1477956
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse