• DECLARE
        @dbname SYSNAME = 'master.sys.databases',
        @Searchname SYSNAME = 'model';

    DECLARE @sqlCommand NVARCHAR(MAX);
    SET @sqlCommand = 'SELECT * FROM ' + @dbname + ' WHERE name = @Searchname';

    EXEC sp_executesql @sqlCommand, N'@Searchname SYSNAME', @Searchname = @Searchname;

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]