[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

SQL Basic Information Collection

Hi,

IN SQL 2000 what can I use in SQL query analyzer to get default information for example:

select * from sp_information_schema not I know this strin is incorrect but what schema commands are there for the purpose of collecting date to a new system your sitting at.

Kind Regards,

JOhan
0
johanvz1
Asked:
johanvz1
1 Solution
 
Kevin3NFCommented:
What kind of data do you want to look at?  System level or database level?

exec sp_configure is a decent start
0
 
RickBeebeCommented:
What default information?

SELECT *
FROM INFORMATION_SCHEMA.TABLES

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES

SELECT *
FROM INFORMATION_SCHEMA.VIEWS

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now