Hoping to get a little help and direction. Here is a little background:
I have an SQL job that will set the default printer, then pause the printer, and then un-pause the printer (all down through xp_cmdshell 'Cscript C:\Windows\System32\prnmngr.vbs -t -p test') and is working with SQL 2008 and Vista 32-bit.
I am trying to put this same job on SQL 2008 but on Windows Server 2008 R2 64-bit OS. However I get an error.
When I try executing I get "Unable to set the default printer Win32 error code 1801" even though i know my printer is named "test".
Any help/direction is much appreciated.