Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Has SQL got Low-level files functions ?

Author  Topic 

giadinhde
Starting Member

1 Post

Posted - 2004-06-29 : 05:07:32
I need some low-level file function. It may be like
File read,
File write,
File seek...
Can you help me now?
Thank alot

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-06-29 : 05:14:11
depends what you are trying to do...

File reads can be done by DTS ( or BCP or Linked Server's), or you can try and get OPENDATASOURCE sql queries against them.
File write - again, DTS ( or BCP or Linked Server's), - not sure if OPENDATASOURCE will work for that, it might.
File Search ... searching in a file, or searching for a file?

Searching for a file could be done, via ugly methods like exec master..xp_cmdshell 'dir /s ', or using undocumented features like xp_fileexists etc.

more details on what it is you actually want to do ?

CiaO

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -