SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Content with tag powershell Rss

Refine your search with one of the following additional tags (with number of items):

SMO (8)     Registered Servers (1)    
SQL Server 2005 (8)     SQL Server 2000 (1)    
Enterprise Manager (1)    
   Items 1 to 12 of 12   
 

Check your SQL Server using Windows PowerShell – Part 1

This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.  Read more...
By Additional Articles 2008/06/26 | Source: Database Journal | Category: powershell
Rating:  Rate this |  Briefcase | 3,025 reads

Powershell/SMO: Unload table schema, dri, perms & data.

PSH script to unload table schema, dri, permissions and data to file(s).  Read more...
By Gordon 2008/06/10 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |  Briefcase | 354 reads

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...
By Chad Miller 2008/05/08 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |  Briefcase | 730 reads

Microsoft Windows PowerShell and SQL Server 2005 WMI Providers – Part 1

Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.  Read more...
By Additional Articles 2007/11/29 | Source: Database Journal | Category: powershell
Rating:  Rate this |  Briefcase | 1,332 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 10

This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.  Read more...
By Additional Articles 2007/10/31 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |  Briefcase | 1,038 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9

Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.  Read more...
By Additional Articles 2007/10/26 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |  Briefcase | 1,498 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8

This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.  Read more...
By Additional Articles 2007/10/23 | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,347 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 7

This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.  Read more...
By Additional Articles 2007/10/19 | Source: Database Journal | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,466 reads

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.  Read more...
By Additional Articles 2007/10/16 | Source: Database Journal | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,424 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 3

Part 3 of this series illustrates how to script PowerShell cmdlets and execute them. Scripting is essential for automation and executing repetitive tasks.  Read more...
By Additional Articles 2007/10/08 | Source: Database Journal | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,594 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part II

Part II of this series discusses more about PowerShell and its features in conjunction with SMO.   Read more...
By Additional Articles 2007/10/05 | Source: Database Journal | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,799 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part I

As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can schedule and run these scripts multiple times.  Read more...
By Additional Articles 2007/10/04 | Source: Database Journal | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,997 reads
   Items 1 to 12 of 12   
 
Most popular

Import/Export SQL Server 2000 Enterprise Manager Registered Servers

Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.   Read more...
By Chad Miller 2008/05/08 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |  Briefcase | 730 reads

Powershell/SMO: Unload table schema, dri, perms & data.

PSH script to unload table schema, dri, permissions and data to file(s).  Read more...
By Gordon 2008/06/10 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |  Briefcase | 354 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8

This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.  Read more...
By Additional Articles 2007/10/23 | Category: SMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,347 reads
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use