• 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,185 reads

Blogs

Power BI – Hungry Median

By

Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...

Top 10 Must-Ask Questions Before Going to the Cloud

By

After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Read the latest Blogs

Forums

Variable Based on Variable in Paginated Report w/ Native Oracle Connection

By dataanalystanonymous

I have an SSRS paginated report where users need the ability to pick and...

IndicatorsPool events causing memory pressure?

By Ian (SSC)

Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...

Sql Server Specs Question

By smattiko83

Hi, I have two different servers that I do a bulk insert on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers