Laquiva,

BCP to a floppy? That's pretty much overkill and misuse of BCP. BCP is designed to get lots of data in/out of a server.

Let your SP return a result set to your ASP in an ADO recordset and write some script code to dump that out to a file. I don't know all the ADO methods off the top of my head it may already have something that will render the recordset into text with a single call.

>I'm using the bcp utility inside a stored procedure to create/save a text file to a floppy. I'm using ASP.NET and whenthe stored procedure is called, it saves the file to the floppy drive on the server instead of the floppy on the user's system. Is there a way to correct this?