|
Comments
|
Chandan Verma on
9/29/2009
Really Helpful
|
|
|
A good look at how to use LinkedServers
|
|
Philip Hickey on
9/29/2009
Very comprehensive
|
|
Sara Karasik on
9/29/2009
somewhat basic.
|
|
Dennis Allen on
9/29/2009
I would like some examples using other data sources. Oracle, Excel, csv and so on.
|
|
Ralph Schwehr on
9/29/2009
I would have liked to see a longer discussion on security options for the linked server connection.
|
|
Shanon Bailey on
9/29/2009
Would like to see how to connect to a linked server that is not a SQL Server db.
|
|
|
Too short but excellent information on Linked Servers
|
|
|
Great explanation about rpc out and not showing password in generating sql script for a linked server. Thank you.
|
|
|
Very simple and very nice
|
|
|
awesome!!!! thank you very much for this vdo.
|
|
|
Really had no idea before this what linked servers were, or what I might use it for. Great intro!
|
|
|
good
|
|
|
Need a discussion of the issues of impersonation.
|
|
Trevor Stumpf on
10/2/2009
How about other data sources such as mysql. I would like to see that.
|
|
|
v good
|
|
|
This certainly makes me want to see more of what can be done.
|
|
|
well done
|
|
Wenda Stephens on
10/16/2009
This helped with the Security tab. Helped us with setting up an user name and password outside of the provider string.
Wish you had examples of setting up a Linked Server using the OLE DB provider for ODBC.
|
|
|
succinct and very helpful!
|
|
Peter Voutov on
12/1/2009
It would have been good to explain what the other RPC option is used for.
|
|
|
Thanks.Not aware of the execute as option.
|
|
|
I enjoy the short topic specific videos, it really helps me as a student of MS SQL Server 2008.
Thank you,
|
|
|
Short and Nice Video
|
|
|
Very easy to understand. Thanks.
|
|
|
Very nice. It would be helpful to mention that certain commands, like TRUNCATE TABLE, can't be used as-is on linked servers and need to be embedded in a EXECUTE AS ('<command>') AT [<linked-server-name>] command.
|
|
|
Would like to see Demo on how to schedule SP via SQL Server Job Agent where SP use linked Server queries.
|
|
John Langston on
3/17/2010
Good basic intro
|
|
|
Good one to configure linked server
|
|
|
Would've liked to see a connection to a non SQL Server DB, otherwise great. Maybe a follow-up some time
|
|
|
good clear speaker, good detail descriptions too
|
|
|
Good Stuff!
|
|
|
Awesome thanx
|
|
|
NowI know
|
|
Robert Bishop on
11/4/2010
good job. made sense!
|
|
Russell Todd on
11/5/2010
should have linked to something else besides another sql server
|
|
|
Excellent Video!
|
|
|
Excellent Video!
|
|
|
It would be nice to have the example use a server instance.
|
|
|
Thank you!
|
|
|
Linked server name may be an alias, previously defined on the local server with SQL Server Configuration Manager.
For queries with joins over two servers you may need the following steps.
First verify the "Distribute Transaction Coordinator" Service is
running on both database server computer and client computers.
1. Go to "Administrative Tools > Services".
2. Start the "Distribute Transaction Coordinator" Service if it is not running. It should be started automatically.
Allow Remote Clients
1. Go to "Administrative Tools > Component Services"
2. On the left navigation tree, go to "Component Services > Computers> My Computer" (You may need to double click and wait as some nodes need time to expand)
3. Right click on "My Computer", select "Properties"
4. Select "MSDTC" tab
5. Click "Security Configuration"
6. Make sure you check "Network DTC Access", "Allow Remote Client", "Allow Inbound/Outbound", "Enable TIP".
7. The MSDTC service will restart.
|
|
|
wasn't sure what rpc was when you were enabling it. Maybe I missed the definition. I'll go look it up :)
Thanks
|
|
|
good
|
|
Tom Hamilton on
12/8/2010
Excellent
|
|
|
good
|
|
|
Excellent run through ... does it work across versions and editions, e.g. could say a SQL Express 2008 R2 link to a SQL Enterprise 2005 ?
|
|
|
Excellent video, but how can one get the script used in the video?
|
|
|
excellente!
|
|
|
Good.
|
|
|
Just what I was looking for! Thanks.
|
|
|
I would have liked to have seen information about other features of the remote server setup: 1) using a domain login, 2) using the Impersonate option, 3) info about needing account delegation turned on in Active Directory to utilize the "be made using the login's current security context."
|
|
|
Great Overview of linked servers
|
|
|
Great concise explanation.
|
|
|
To the point
|
|
|
Very useful
|
|
|
Need more Video to connect to files and other objects
|
|
Dustin Dorsey on
2/14/2012
Good demonstration, but it sounded like the narrator was eating food while talking
|
|
|
The major problem most folks have with linked servers is always security issues. You could more than likely create a video that would address these issues in more detail.
|
|
|
Very helpful and timely!
|
|
|
I wish you would have given an example using the option "Be made using the login's current security context." Especially in terms of Kerberos Security.
|
|
Richard Scott on
2/14/2012
More mystery removed!
|
|
|
Want to know some more exapmles
|
|
|
Andy is alaway very good
|
|
|
Would have liked to seen a linked table to another data source, like Oracle, for example.
|
|
|
I would like to see a video on linking other types of servers such as DB2.
|
|
|
Awesome! Actually learned a few things I did not know.... Great work!
|
|
|
perfect!!!!
|
|
|
Very nice video, but we need more detail video to understand everything about Linked Server.
|
|
|
like to have more detail about security settings
|