Month: January 2005

nnnnnGet CD Key and MDAC Version from SQL Server 2000 – ExtremeExperts: How can I find the SQL Server CD key I used to install? It would be great to get this information from my desktop. Answer: As said the easy way is to get to the remote machines registry key settings and search for…

nnnnnUsing Excel to Pull Data from SQL ServernUsing Excel to Pull Data from SQL ServernMichael SchmalznnBefore I start, I want to emphasize that this example uses Excel for the functionality as opposed to Enterprise Manager or any of the SQL Server User Interface functionality. In the first article that I wrote about getting data from…