sp_tables and sp_databases?
Try connecting to the MASTER database ( if you can ) and TRY:
SELECT * FROM SYSFILES
SELECT * FROM SYSFILES1
SELECT * FROM DATABASES
SELECT * FROM SYSPERFINFO
Also, sp_databses and sp_tables are in plain text if you go through
Enterprise Manager to the Stored Srocedures section.
Tim
----- Original Message -----
From: "Mark Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 15:23
Subject: RE: <cfquery> Question
> There is a SqL Server stored procedure that will describe a database for
> you. Off the top of my head, I can't remember the name of it but you can
> find it in books on line.
>
> If I can remember the name, I'll pass it along.
>
> Mark
>
> -----Original Message-----
> From: Edward Chanter [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 06, 2001 8:10 AM
> To: CF-Talk
> Subject: <cfquery> Question
>
>
> I'm probably being a dunce here but does anyone know a sql query that
> will
> list out all the tables in a particular sql7 database...?
>
> Thanks in advance...
>
> -= Ed
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
