Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report using INFORMATION_SCHEMA views

Status
Not open for further replies.
ColinGregory

ColinGregory

Technical User
Feb 16, 2001
39
US
Does anyone know how to build a report using INFORMATION_SCHEMA views in SQL Server 2K.

These views were easily accessible in SQL Server 7 but don't appear in 2000.

Thanks in advance
 
Sort by date Sort by votes
If you mean sysobjects, syscolumns, etc, they appear in mine.

Perhaps you don't have permission?

-k

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
670
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
635
Ivan Kok
Ivan Kok
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
652
sal21
sal21
CrystalUser90
  • Locked
  • Question
Same field on two tables, merge into one field on report 1
Replies
2
Views
645
CrystalUser90
CrystalUser90
hpl2001
  • Locked
  • Question
Report stored in history getting updated
Replies
5
Views
196
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top