My question is: Is there a way to

[AER]

My question is:
Is there a way to make a straight call from stored procedure in SQL Server 7.0 to the file system ?

Sincerely,
Alex

 

[tlbroadbent]

There are no direct calls to the file system. You can use Bulk Insert to read a flat file and insert the data into a table with T-SQL. There are a number of extended stored procedures that allow access to the file system. These undocumented exetended stored procedures are listed at

http://www.sql-server-performance.com/ac_extended_stored_procedures.asp.

I'm unclear of your exact need but hope this info helps. Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous

 

[xcata]

It depends what do you want to do. For example if you have in your system scrrun32.dll, you may use FileSystemObject to gain acces to disk. For this you must use extended stored procedures sp_OACreate, sp_OAMethod to create and call methods from activeX objects.

Another way, much more limited is the extended stored procedure xp_cmdshell. With this you may call all dos commands.

xcata.