SA

A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2012-05-14 (first published: 2012-04-09)

1,016 reads

Blogs

While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...

(This is the second post in a three-part series on how AI is changing...

I had seen these roles in various instances, but never dug into the new...

Comments posted to this topic are about the item Pay for Performance, which is...

Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...

Comments posted to this topic are about the item The ##MS_DatabaseConnector## User

On SQL Server 2025, I run this code as a sysadmin:

CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567'
GO
ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo
GO

I then login as Demo and run this:

USE sandbox
go
SELECT CURRENT_USER

What is returned?