Users/Groups Delete Disabled Users Delete Disabled Users Enum. Users Enum. Users Delete Users Add Users Enum. Groups Enum. Groups Change Groups Add Group Active Directory Enum. AD Groups Enum. AD Users List AD Users w/Prop Join AD Users NIC/IP Addresses Get IP Addresses Get IP Addresses Backup and Restore IP's Add IP's NIC Settings OS/Hardware OS Info Script OS Info Script All OS Info Script All OS System Count Hardware Info Script Hardware Info Script #1 Hardware Info Script #2 CPU Settings Enum. Printers Disk Quotas Disable Disk Quota Enable Disk Quota Disk Quota Query Disk Quota Update Shares/Files/Sessions Enum. Shares Enum. Shares Enum. All Shares Enum. Open Files Enum. Open Files Enum. Open Sessions Others Servers Uptime DNS Stuff Services Enum Services Enum Enum Processes Enum Hot Fixes MS FTP Server FTP VD Query FTP VD Delete FTP Site Enum. MS WWW Server WWW Site Enum. Enum Mime Types Enum Mime Types Application Pools Application Pool Enum Application Pool Enum Create Application Pool Create Application Pool Delete Application Pool Enum Apps in App Pool Enum App Pool Settings Move Apps Between App Pools Others IIS Component Probe IIS Status Enum SQL Dbases Backup SQL Dbases Orphan SQL Users List AD/WG My AD/WG Name My PC Name Enum AD Computers Contact Us Form SM Login Form Code Imail Login Form Code Enum. Domains in Imail Enum. Users in Imail CDONTS Component CDOSYS Component SA SMTP Component App Pool Monitor Ping and Tracert Hard Drive Monitoring Uptime Monitoring Desktop Lock CD Key Revealer MIK Restarter Site Map About the Site RSS Feeds I Read Custom Scripts Visitor #:     windowsadminscripts.com www     Script: Orphan SQL Users This script should be used after restoring a sql server and all its dbases. The script will enumerate all dbases and the users associated with the dbase and it will fix the orphaned users that normal happens after a dbase is restored in SQL 2000. Email Address To Send Sample Code To: @    '***************************************************** ' Script Written by Larry Heintz ' Dec 2007 www.windowsadminscripts.com ' This script should be used after restoring a sql server ' and all its dbases. The script will enumerate all dbases ' and the users associated with the dbase and it will fix ' the orphaned users that normal happens after a dbase ' is restored in SQL 2000. ' ' usage cscript sqlusers.vbs *will use local pc for server ' or ' usage cscript sqlusers.vbs /computer:[sql server name] '***************************************************** Dim args,strDBServerName Set args = Wscript.Arguments.Named if args.Item("computer") <> "" then strDBServerName = args.Item("computer") else strDBServerName = getComputer() end if Call getDbases (strDBServerName) Sub getDbases (sqlserver) Dim objSQLServer,colDatabases,objDatabase Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect sqlserver Set colDatabases = objSQLServer.Databases For Each objDatabase In colDatabases wscript.echo "DBName: " & objDatabase.name users sqlserver,objDatabase.Name Next Set colDatabases = nothing Set objSQLServer = nothing End Sub Sub users (sqlserver,dbname) Dim objSQLServer,objDB,colUsers,objUser Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect sqlserver Set objDB = objSQLServer.Databases(dbname) Set colUsers = objDB.Users For Each objUser In colUsers 'Uncomment below line to see dbase name, dbase user and dbase login username 'wscript.echo "DBName: " & dbname & ","User: " & objUser.Name & ","Login: " & objUser.Login wscript.echo "EXEC sp_change_users_login 'Auto_Fix', '" & objUser.Name & "'" Next wscript.echo "--------------------------------------" Set colUsers = nothing Set objDB = nothing Set objSQLServer = nothing End Sub Function getComputer() Dim objNet Set objNet = WScript.CreateObject("WScript.Network") getComputer = objNet.ComputerName Set objNet = Nothing End Function Click Here to Download the VBS Script Copyright 2006 WindowsAdminScripts.com all rights reserved.