Yesterday I was exploring Sql Server Management Studio, when I spotted Linked servers. I thought I will investigate what that and started trying out the options. So I right clicked on linked server, only three options came up as shown below.
I clicked on the New linked server .
I was browsing through the provider list as shown below and was keen to learn more about the provider for Microsoft Directory Services.
I thought I will experiment by using excel hence I gave the product name as excel, and data source -- a file in my c directory. But did not know what to give as a Provider string and location. I just gave the Provider as Excel 8.0 which is commonly used for excel in reports. Left the location blank and clicked ok.
To my surprise there was no error and the Test linked server was created as shown below.
So I right clicked on the test and chose TEst connection and the connection succeeded.
I am happy that it all went well but yet since there were no other options that are visible on how to use this linked server I thought I would find out when I had a bit more time on hand. So I will post my findings in another post.
Week 6 update: Yesterday the class was a bit different because it started off with a Database Fundamentals test. There were 20 questions ...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
When I tried to access the report manager after a fresh installation of Sql Server Reporting Serivces 2016 using the url http://localhost/R...