Technical Article

Sincronizar SID DB user com SID Login SQL

Quando você restaura um banco ou 'atacha' ao seu servidor de outro servidor, pode ocorrer de o usuário que existe no banco não sincronizar com o login do SQL server anteriormente criado com DBO desse banco, então esse script faz exatamente isso, pega o SID do SQL e dá um UPDATE no SID do usuário […]

2005-09-06 (first published: )

342 reads

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Has SQL Server Performance Improved?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Has SQL Server Performance Improved?

Is TemporalTable SysStartTime available before performing an insert/Update?

By Dwaine Wright

I want to align a Date column (datetime2(7)) with the same full resolution date...

multiple PAGELATCH_UP waits on data file

By bobrooney.81

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers