April 21, 2003 at 12:00 pm
How to print a word document from sql server
April 24, 2003 at 8:00 am
This was removed by the editor as SPAM
April 24, 2003 at 9:24 am
If I understand correctly, you are asking about printing a document inside a stored procedure.
This can be achieved using SP_OACreate to create a word object and then issuing a print method.
However note that this is very high memory consuming and might cause instability for sql*server. Instead better idea would be to run a program outside sql*server in batch mode to get documents and print it.
Can you please provide more details on your requirement.
April 25, 2003 at 8:29 am
I have a Word Doc on server , which i need to populate with the records from table and then print it off from the network server
I need to write a procedure in SQL server for the above explanation
May 2, 2003 at 5:25 am
I see your point. However in this case you can write a vb program to populate the word document from table and printing it. You can then schedule this program to run from NT machine.
Can you please clarify why you need this in Stored Procedure?.
May 20, 2003 at 9:24 am
I can do that but i need to print off that document from a wireless hand held device
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply