Copy Server problems

#41

Hi Mark.

My understanding of linked servers is it can allow remote calls for stored
procedures.

I want to make sure that there's no triggers or anything that would invoke a
remote call of a stored procedure on Server 1, from Server X. Server X is a
development box, we're just trying to consolidate all databases here.

Hence I am curious about a "read only" mode. So the link is present, but
perhaps I disable any remote stored procedure calls, and grant only SELECT on
all the remote tables? Any INSERT UPDATE DELETE or executes issued from
Server X to Server 1 would fail.

"Mark Han[MSFT]" wrote:

Quote:

Hi Greg,

Thank you for the update.

I understand that you would like to add server 1 as a linked server on
server X.

in order to address your concerns, I would like to explain the following
1 Please descrip the following in detail. What you meaning "use"?
I can ensure server X never actually *uses* the links

2 when creating linked server, it is allowed for us to grant different user
different rights, we can just give th read role to the user who will visit
the linked server.

3 when using DTS, we can use another user who have read/write role on the
databse in the linked server.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

#42

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#43

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#44

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#45

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#46

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#47

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#48

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#49

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

#50

Thanks Mark.

Okay, I am now using the Transfer Database task instead. I enter the source,
destination, and select a single database to copy.

When I click on the File Locations tab, Enterprise Manager freezes. Any ideas?

Thanks,
Greg

"Mark Han[MSFT]" wrote:

Quote:

Hi Greg,

Thank you for the reply. To create a linked server, we can collect the
information from the linked server and local server togther at same time.

About your concern, it is no need to created linked server on Server X. it
is more convenient to you to copy the database from server 1 to server X
and then we can set the appropriate role to appropriate user.

Besides, about how to copy databse from one server to another, the detail
steps are in my previous response.

Hope the above helpful.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==