SQLServer.in

DECLARE @dbname varchar( 128 )
SELECT @dbname = ‘tempdb’ — test
– In SQL6x/70/2000
IF DB_ID( @dbname ) IS NOT NULL
    PRINT ‘DB Exists…’
ELSE
    PRINT ‘DB does not exist…’

– In SQL70/2000
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
           WHERE CATALOG_NAME = @dbname )
    PRINT ‘DB Exists…’
ELSE
    PRINT ‘DB does not exist…’

IF DATABASEPROPERTY( @dbname , ‘IsOffline’ ) IS NOT NULL
    PRINT ‘DB Exists…’
ELSE
    PRINT ‘DB does not exist…’

select convert(varchar(30),object_name(id)) [Table Name], rows from sysindexes
where object_name(id) not like ‘sys%’ and indid = 1
order by object_name(id)
Use DBCC UPDATEUSAGE to update the sysindexes table