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 […]

2003-01-08

124 reads

Blogs

Checkpoint Analysis: Your Exclusive How-To with XEvents

By

Checkpoints are essential in SQL Server to help with the durability and reliability of...

Goals for 2022

By

I set goals at the beginning of last year, and I’m doing the something...

Daily Coping 14 Jan 2022

By

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

Read the latest Blogs

Forums

Good t-sql script possibly to list partitions and used/free space on Linux

By curious_sqldba

I have quite a few scripts to monitor space on Windows server, but I...

Power Query SSIS Error

By water490

Hi I am using SQL Server 2019 and Visual Studio 2019. There are two...

Adding Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Time

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding Time

See possible answers