Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > SQL DMO


Search:
What's New - What's Hot
Utility Belt: Caching Demo SQLserver     
Total Hits: 184  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

To make applications faster and provide an added benefit to using UtilityBelt all functions internally use DataTables to fetch data from the database support caching in an easy transparent fashion by setting properties instead of changing the actual library calls....

Utility Belt: Sproc with Parameters Demo     
Total Hits: 139  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.

Here is the Sproc with parameter sample:...

Using SQL DMO and Windows Script to customize script generation     
Total Hits: 887  |  Today: 0Author: Ashok Hariharan      Rating:  
Read Reviews | Write Review |  Your Rating: 

Creating and modifying table scripts can quickly turn into a tedious chore. The article illustrates a method to automate this task by using SQL-DMO and Windows Script to generate customized scripts for SQL server table objects...

SQL-DMO - Using the '2' Objects     
Total Hits: 817  |  Today: 0Author: Andy Warren      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you've used SQL-DMO very much you may have noticed that there are lots of almost duplicate objects. Examples are SQLServer vs SQLServer2, Database vs Database2, and many others. One question I get a lot is "which object should I use?", which is a fair question and worth a brief discussion....

SQL-DMO for Beginners     
Total Hits: 1187  |  Today: 0Author: Steve Jones      Rating:  
Read Reviews | Write Review |  Your Rating: 

How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
...

SQL Distributed Management Objects     
Total Hits: 1124  |  Today: 0Author: Carvin Wilson      Rating:  
Read Reviews | Write Review |  Your Rating: 

How to use the SQL Distributed Management Objects from ASP...

Utility Belt: Search SQLServer Demo     
Total Hits: 175  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.
The Search Code is one demo of Database "Utility Belt" functionality....

Using SQL DMO for automated Database Backup and Restore     
Total Hits: 843  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL DMO or SQL Distributed Management Objects are available through a Development library called SQLDMO.DLL from Microsoft. This Library can be used to automate the repetitive tasks needed to be done on, SQL Databases and Servers using Enterprise manager. Tasks like Back up, Restore, Scheduled Backup etc., can be easily automated. There are a large number of combinations in which this can be used apart from Backup and restore. This could be automating even the task of creation and removal of dat...

SQL User Tables To ArrayList (DMO)     
Total Hits: 1143  |  Today: 0Author: Curtis Swartzentruber      Rating:  
Read Reviews | Write Review |  Your Rating: 

Get A List of Tables From SQL Server using DMO...

The Curse and Blessings of Dynamic SQL     
Total Hits: 121  |  Today: 0Author: Erland Sommarskog      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article I will discuss the use of dynamic SQL in stored procedures and to a minor extent from client languages. To set the scene, I start with a very quick overview on application architecture for data access. I then proceed to describe the feature dynamic SQL as such, with a quick introduction followed by the gory syntax details. Next, I continue with a discussion on SQL injection, a security issue that you absolutely must have good understanding of when you work with dynamic SQL. This ...

Utility Belt: Sproc with No Parameters Demo     
Total Hits: 132  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.

Here is the Sproc with no parameter sample:...

Creating SQL Server Database Dynamically in .NET using SQL DMO     
Total Hits: 306  |  Today: 0Author: Joshy George      Rating:  
Read Reviews | Write Review |  Your Rating: 

It is a sample ASP.Net (VS2005) application for creating a database in Sql server Runtime. I have used SQL-DMO dll. This article will show you how to create a database in Sql server 2005 & 2000....

Introduction to SQL-DMO     
Total Hits: 1228  |  Today: 0Author: Damian      Rating:  
Read Reviews | Write Review |  Your Rating: 

Most SQL Server administrative tasks are programmable thanks to a set of objects known as SQL-DMO. This article introduces the concepts of programming DMO, and steps you through some basic, and commonly requested examples....



Disclaimer - Privacy
© 2002-2017 DevASP.net