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.
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...