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

Blogs

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Gathering More Digital Data with Tile Slim

By

After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...

Read the latest Blogs

Forums

private messages gone

By frederico_fonseca

hi, Maybe I'm doing something wrong now, but it seems that the option to...

How to get spid of jobs that are running along with job name

By coolchaitu

Hi, Can you please let me know how to get spid of jobs that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers