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
 SQL Server Development (2000)
 Printing a text file from a SQL Server stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-12 : 15:47:56
Paul writes "I have a list of subscribers in a database, with address information for each subscriber. Also stored on the database is a standard message I wish to print for this list of subscribers. The data stored on the database is captured via a WEB-based front-end written using javascript, vbscript and HTML.

From a stored procedure (or some other way?), I want to select each subscriber and the standard message from the database, create a text file with the subscriber address details and the standard message, and automatically print this text file.
Do you know if this is possible?

I am running SQL Server 7.0 on windows NT Server 4 SP6.

I would really appreciate any advice, help or suggestions etc.

Many thanks."
   

- Advertisement -