This powershell script is sample code to run query against multiple SQL Servers and export the combined output to Excel. This Excel file is later sent as email attachment using hotmail.
Related email thread: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/987d48c0-a82d-4424-8699-cdd0b2bc9c51
# This posting is provided “AS IS” with no warranties, and confers no rights.
Script can be also downloaded from emailResultsMultiServerQuery.ps1
Highlights:
- Small download footprint
- Very quick installation
- Simple Installer – No installer options – (Just Accept EULA)
About LocalDB: http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/simple-installer-for-localdb-has-shipped.aspx
Download LocalDB
1) Goto : http://www.microsoft.com/sqlserver/en/us/editions/express.aspx , click on “Download 2012 RC0 EXPRESS”
2) If Windows Live ID sign-on was prompted sign in using your live id
3) Select Language and platform, Select “LocalDB”
http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx
4) Wait till download manager completes downloading SqlLocalDB.MSI
Installation:
Launch Installer SqlLocalDB.MSI
Unattended Installation:
1: msiexec /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES
Management tools:
You can install SQL Management Studio Express from
http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx
Connecting to LocalDB
- Launch Management studio
- In Connection dialog, connect to (localdb)\v11.0
-
References:
http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/simple-installer-for-localdb-has-shipped.aspx
http://blogs.msdn.com/b/sqlexpress/archive/2011/10/27/net-framework-4-now-supports-localdb.aspx
Theme: Rubric. Blog at WordPress.com.
