Viewing 2 posts - 1 through 2 (of 2 total)
All logins and rolas together:
SELECTCase when ROW_NUMBER() OVER(PARTITION BY sp.name ORDER BY r.name DESC) = 1then'IF(SUSER_ID('+QUOTENAME(SP.name,'''')+') IS NULL)BEGINCREATE LOGIN '+QUOTENAME(SP.name)+' WITH...
March 29, 2018 at 10:47 am
#1985002
This is fast sql script that will make a sql script (create linked server command) for linked servers (made by me), but without password:
select'USE [master]GO
March 29, 2018 at 9:59 am
#1984979