Re: Client side printing

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 15:33:28 +0100

xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
the server machine, but the destination is specified as the client? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Santosh" <Santosh@discussions.microsoft.com> wrote in message 
news:A37189CF-9AFE-403A-97FC-2586C96C275B@microsoft.com...
> Hi
>
> I am trying to print Query Result directly to the printer from Client
> machine. I managed to do this on Server machine. Where I had written SP which
> accepts SQL as parameter and using osql and xp_cmdShell command I am
> outputting CSV file to printer. I want to do same from client machine but I
> want print out should get printed on client printer not on Server.
>
> Any ideas or suggestions??
>
> Many thanks in advance.
>
> Regards,
> Santosh
>

Relevant Pages

  • Re: Remote Desktop & Wake-on-LAN
    ... just that the server machine ... go into a timed suspend until I reboot the client, ... >> a Remote Desktop client connection. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Which is best - recordsets/VBA V SQL statements for updating data
    ... One typical requirement was a client who required a report that forecast ... > SQL is better than Recordset Updating and Vice Versa. ... Is this a job for SQL or for Recordset ... > Procedure or UDF on the Server machine, using loops, conditional, ...
    (comp.databases.ms-access)
  • Re: Err.Raise in COM+ Component loses Err.Source and Err.Description
    ... error" on 2 different server machines running the same server-side package. ... I wish I had another Win2000 machine I could try as a client to ... Using the same SERVER machine and varying CLIENT machines running the same ... Set cnDBMS = New Connection ...
    (microsoft.public.vb.general.discussion)
  • Re: Client side printing
    ... Thanks Tibor, yes what you are suggesting, makes sense. ... server by other users. ... everyone at client-side got there own printers, so I doubt if client admin ... I managed to do this on Server machine. ...
    (microsoft.public.sqlserver.server)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)