"how to check if database exist on remote server through sql query" Code Answer

so, i assume you already have all your server linked and you used an account, which can read the schema. than script will be something like this:

select top 0 * into #tbl_server_dbs
from tbl_server_dbs

declare serverdbs cursor local static forward_only 
for select clientname, servername, databasename from tbl_server_dbs

declare @clientname nvarchar(128), @servername nvarchar(128), @databasename nvarchar(128);
declare @s nvarchar(4000)

open serverdbs
fetch next from serverdbs 
into @clientname, @servername, @databasename

while (@@fetch_status <> -1)
begin
    set @s = n'select ''' + @clientname + n''', ''' + @servername + n''', name 
        from [' + @servername + n'].sys.databases
        where name = ''' + @databasename + n''';';

    print @s
    insert into #tbl_server_dbs (clientname, servername, databasename)
    exec(@s);

    fetch next from serverdbs 
    into @clientname, @servername, @databasename
end

close serverdbs
deallocate serverdbs

select * from #tbl_server_dbs;

By mendosi on April 24 2022