sql server querying and exporting results
Posted on 2013-06-03
I’ve been given a task of logging onto around 20 sql servers (ranging from SQL 2000 to 2008) and running basic query and exporting the results to excel. I’ve been given a reasonably low privilege account which should be sufficient to do the task, but I am very new to SQL Server. I have an admin level domain account to remote onto each SQL Server, but from there it’s pretty new to me how to login to SQL, run a query and export the results. Can any of you do a set of screenshots of once you’ve remoted onto a windows server, how you then login to SQL (with a SQL account), run a query (against system databases) and export the results to excel.