• Interests: Triathlons & Guitar

Script Database Objects

Others have asked for this throught the disussion threads so I thought others might benefit as well.This SQL-DMO script will create multiple files for server logins (SIDs & encrypted passwords), database users, tables, procedures and views.1.  Alter the script to reflect your server and path for output files.2.  Create the job (ActiveX Script).Be great!Michael

2002-09-20

1,186 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Server 2019 PMEM

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2019 PMEM

Query Optimizer Suggests Wrong Index and Query Plan -- Why?

By Mike Byrd

Comments posted to this topic are about the item Query Optimizer Suggests Wrong Index...

UX Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item UX Matters

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers