I'm trying to setup a job in SQL Server 2008 to email me a report of qwinsta results for a few servers. I'm running this:
[code]xp_cmdshell 'qwinsta /server:servername'[/code]
Result:
No User exists for *
But if I run... [code]xp_cmdshell 'qwinsta'[/code] ...it works. It's like it can't see remote PC's from the command line or something. I've tried on a few of our SQL servers. Anybody ever try this before?
Sorry, you need to Log In to post a reply to this thread.