Scripting SQL Management Objects in Windows PowerShell, 1st Edition

Scripting SQL Management Objects in Windows PowerShell, 1st Edition

Scripting SQL Management Objects in Windows PowerShell, 1st Edition

eBook
Author(s):Johnson
Format: Print PDF
Published year: 2008
Publisher: Wiley
Language: English
ISBN: 9780470279359

Summary

This Wrox Blox shows how to communicate with SQL Server using SQL Management Objects instantiated on-the-fly in Windows PowerShell scripts. Topics include how to create Windows PowerShell scripts that use SQL Management Objects (SMO) to manage and program SQL Server. In addition, you will learn about areas of potential difficulty and see how to avoid them—for example, the use of '$' in instance name, quote nesting rules, connection pooling, and schemata. The explanations in this Wrox Blox are focused on numerous code examples, and show you how to do the following: load SMO; create a server object; get a user’s credentials from the UI into a safestring; connect to SQL Server using SQL Server authentication; connect to SQL Server using Windows authentication; profile a server instance by examining its properties; use WMI to examine and configure a server’s Windows service; use

Similar books

© 2026 VitalBooks. All rights reserved.