Wrox Home  
Search
Scripting SQL Management Objects in Windows PowerShell (0470279354) cover image

Scripting SQL Management Objects in Windows PowerShell

Willis Johnson
ISBN: 978-0-470-27935-9
Wrox Blox PDF
33 pages
January 2008
Electronic Version: US $6.99 Purchase This Download

About This Title  |  Download Code  |  Errata
Table of Contents
Loading the SMO Assemblies.

Creating and Modifying the Server Object.

Specifying an Instance Name.

Specifying an Authentication Method.

Specifying Credentials.

Disabling Connection Pooling.

Using a Server Object.

Managing the SQL Server Service with PowerShell.

Listing the Methods of the SQL Browser's WMI Object.

Getting the Value of a Specific Property.

Built-in PowerShell Cmdlets.

Get-Service.

Set-Service.

Starting, Stopping, and Restarting.

Working with Database Objects.

Creating a Database.

Creating Schemata and Tables.

Summary.

About Willis Johnson.

Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free