SQL Server 2022 Revealed by Bob Ward

Author:Bob Ward
Language: eng
Format: epub
ISBN: 9781484288948
Publisher: Apress

Virtual machine or computer with minimum of two CPUs and 8Gb RAM.

SQL Server Management Studio (SSMS). The latest SSMS 18.x will work, but SSMS 19.x has a new visualization for ledger tables, so the examples in this exercise were done with the latest SSMS 19.x build.

Get the scripts for this exercise from the book samples at ch06_meatandpotatoes\security\sqlledger.

Note

Any name of identifiable information in this exercise is purely fictional and does not represent any real person.

Setting Up the Exercise

We will create two new SQL logins and a database for the exercise:1.

Execute the script addsysadminlogin.sql to add a sysadmin SQL login. This script executes the following T-SQL statements:USE master;

GO

-- Create a login for bob and make him a sysadmin

IF EXISTS (SELECT * FROM sys.server_principals WHERE NAME = 'bob')

BEGIN

DROP LOGIN bob;

END

CREATE LOGIN bob WITH PASSWORD = N'StrongPassw0rd!';

EXEC sp_addsrvrolemember 'bob', 'sysadmin';

GO

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.