Technical Article

Updating Changed Passwords for warm Servers

One of the challenges weve faced is changing passwords in a warm server to reflect changes made to the live server.  The initial transfer of users and passwords was performed by the   sp_help_revlogin   script provided by Microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;246133.  The difficulty with this script was once the users are in place, you cant sync changed […]

You rated this post out of 5. Change rating

2003-01-08

125 reads

Technical Article

Copying Backups using XP_CMDSHELL

This script is designed to backup the database, and copy it over the network to our backup server.  The requirement for this particular database is 7 days of data kept on the LAN.  The share on the backup server is mapped to the Y:\ drive.  The datename function is used over the datepart function for […]

You rated this post out of 5. Change rating

2002-12-08

351 reads

Blogs

Blogging for the Tech Professional at Denver Dev Days

By

For those that attended my talk at Denver Dev Days, here are the slides:...

Getting AI Written Unit Tests

By

As a part of my AI experiments, I decided to ask CoPilot to write...

A New Word: Slipfast

By

slipfast adj. longing to disappear completely; to melt into a crowd and become invisible,...

Read the latest Blogs

Forums

Software Flexibility (Avoiding the next hack)

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Software Flexibility (Avoiding the next...

Roles on tempdb

By cphite

A co-worker asked me a question today and I couldn't come up with an...

Delayed tcp acknowledgement registry setting

By Rasmus Remmer Bielidt

Our IT department contacted me recently and asked if they should change the default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers