SQL 2000 - Queries

 

SQL 2000 – Queries  > GD - PTBS

Contents 1       DBA Queries. 1 1.1        List of DBs in a Server. 1 1.2        Server, DB, Object, Type. 1 2       Developer Queries. 2

 

1         DBA Queries

1.1       List of DBs in a Server

SELECT * FROM sysdatabases order by dbid

1.2       Server, DB, Object, Type

select @@Servername 'Server', DB_NAME() , name, xtype from sysobjects order by xtype

2         Developer Queries