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.
Yesterday I have concluded the 12 weeks databases and data visualisation classes by running a #powerbi data visualisation competition for...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...