Let sql server code works for all SQLServer versions

[MrKBA]

Hello, The code below works fine with SQL Server 2008 But it seems to be deleted from newer versions of SQL Server. How can change it so it works fine for all versions ? Thank you

IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sac_manager')
exec sp_droplogin 'sac_manager';
exec sp_addlogin @loginame = N'sac_manager', @passwd = N'', @defdb = N'SAC_DB';
USE [SAC_DB]
exec sp_adduser 'sac_manager'
exec sp_addrolemember 'db_owner', 'sac_manager';

[Lost User]

Which part? There is no separate set of commands that work on "all" versions. You'll have to find the part that is deprecated and find some replacement.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]