This message always apears afer restart of DB server and also forced stop of SQL service.

• This reply was modified 7 months, 3 weeks ago by  ljubafm81.

All logins and rolas together:

SELECT
Case when ROW_NUMBER() OVER(PARTITION BY sp.name ORDER BY r.name DESC) = 1
then
'
IF(SUSER_ID('+QUOTENAME(SP.name,'''')+') IS NULL)
BEGIN
CREATE LOGIN '+QUOTENAME(SP.name)+
' WITH...

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