SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags SMO, powershell Rss

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

SQL Server 2005 (7)    
   Items 1 to 8 of 8   
 

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 | 377 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,536 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,384 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,507 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,457 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,632 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,843 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 | 2,058 reads
   Items 1 to 8 of 8