Hi Howie, how are  things?

Check out http://www.swynk.com/sqlhome/scriptlibrary.asp , they'll have most
of the scripts you are looking for (version 6.5 & 7 ). You 'll need to be
DBowner or SA for most of them though. Otherwise connect though OleDB would
work ..

Justin MacCarthy


>I'm trying to import data from a remote server for which I have FTP access
>but not access to the MSSQL Server.  I can get all the records from the
>remote server but what would make life easier would be the ability to:
>
>1 - get a list of all tables in the data source
>2 - get the attributes (data type) of each field in a particular table.
>
>Any ideas?
>


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to