SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server --> File
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 04/21/2008 :  07:32:49  Show Profile
Other that reading from and writing to a database, can SQL interact with OS files? (not .MDF or .BAK or .TRN files)

I need to generate a text file from SQL. There must be a method. Extended procedure? There is a stored procedure working. The output is in a SELECT statement, going nowhere. I tried PRINT, but this turns the output string into a presumed error...

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/21/2008 :  07:39:03  Show Profile  Visit SwePeso's Homepage
BCP?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 04/21/2008 :  08:07:42  Show Profile
How do you run BCP from inside a stored procedure?
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 04/21/2008 :  10:08:30  Show Profile
The answer to my question

is

xp_cmdshell
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000