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