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
SMO
Refine your search with one of the following additional tags (with number of items):
SQL Server 2005
(19)
Backup / Restore
(1)
powershell
(8)
Programming
(1)
Administration
(1)
SQL-DMO
(1)
Items 1 to 20 of 22
Next 20 >>
Using SQL Management Objects to create and restore SQL Databases.
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
Read more...
By
Amriteshwar Singh
2008/06/18
|
Source:
SQLServerCentral.com
|
Category:
SMO
Rating:
|
Discuss
|
Briefcase
|
3,968 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
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
Read more...
By
Brandie Tarvin
2007/03/13
|
Source:
SQLServerCentral.com
|
Category:
SMO
Rating:
|
Discuss
|
Briefcase
|
5,380 reads
SQL Server Management Objects: Lessons from the Wild
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
Read more...
By
Additional Articles
2007/11/13
|
Source:
DevX
|
Category:
SMO
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,751 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,425 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
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 6
Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.
Read more...
By
Additional Articles
2007/09/05
|
Source:
Database Journal
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,493 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 5
Part 5 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to create databases.
Read more...
By
Additional Articles
2007/08/22
|
Source:
Database Journal
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,568 reads
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.
Read more...
By
Additional Articles
2007/07/24
|
Source:
Database Journal
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,407 reads
SQL Server Management Objects
A good article on using SMO in SQL Server 2005.
Read more...
By
Additional Articles
2007/07/18
|
Source:
Microsoft MSDN
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,875 reads
SQL Server Management Objects
In this column, I discuss how SMO can be used to examine a database’s objects and to perform a variety of administrative tasks.
Read more...
By
Additional Articles
2007/06/18
|
Source:
MSDN Communities
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
2,148 reads
Alert-based Transaction Log Backups using SMO
Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.
Read more...
By
Additional Articles
2007/05/07
|
Source:
SimpleTalk
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,558 reads
PowerSMO at work part 2
Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.
Read more...
By
Additional Articles
2007/04/02
|
Source:
SimpleTalk
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,353 reads
PowerSMO At Work Part I: DBA Scripts and Functions
Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO functions to manage the extended properties of SQL Server objects.
Read more...
By
Additional Articles
2007/03/13
|
Source:
SimpleTalk
|
Category:
SQL-DMO
Rating:
Rate this
|
Briefcase
|
2,123 reads
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
Read more...
By
Brandie Tarvin
2007/03/13
|
Source:
SQLServerCentral.com
|
Category:
SMO
Rating:
|
Discuss
|
Briefcase
|
5,380 reads
Items 1 to 20 of 22
Next 20 >>
Most popular
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
Read more...
By
Brandie Tarvin
2007/03/13
|
Source:
SQLServerCentral.com
|
Category:
SMO
Rating:
|
Discuss
|
Briefcase
|
5,380 reads
Using SQL Management Objects to create and restore SQL Databases.
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
Read more...
By
Amriteshwar Singh
2008/06/18
|
Source:
SQLServerCentral.com
|
Category:
SMO
Rating:
|
Discuss
|
Briefcase
|
3,968 reads
SQL Server Management Objects
A good article on using SMO in SQL Server 2005.
Read more...
By
Additional Articles
2007/07/18
|
Source:
Microsoft MSDN
|
Category:
SMO
Rating:
Rate this
|
Briefcase
|
1,875 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use