SQLServerCentral.com Content tagged T-SQL, SQL-DMO

Logins, Users, and Roles - Getting Started

Fri, 30 Sep 2005 06:00:00 UT

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.

Creating a Script from a Stored Procedure

Fri, 02 May 2003 06:00:00 UT

Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello.

Logins, Users, and Roles - Getting Started

Fri, 30 Sep 2005 06:00:00 UT

Managing Jobs - Part 1

Fri, 31 Jan 2003 07:00:00 UT

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Restoring Using DMO - Getting File List and No Recovery

Tue, 15 Oct 2002 06:00:00 UT

Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code!

Automate Writing Stored Procedures

Mon, 25 Jun 2001 06:00:00 UT

This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Thu, 14 Jun 2001 06:00:00 UT

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.