Hey, in fact I was just saying about the WMI permissions and to be honest I dont read all the posts hehehe.Sorry 🙂

Have you tried ?

http://vniklas.djungeln.se/2012/08/22/set-up-non-admin-account-to-access-wmi-and-performance-data-remotely-with-powershell/[/url]

Anytime Man 🙂

USe Chad Miller´s Out-DataTable and Write-DataTable

it use Bulk Insert.

Try to change the Job Owner to a NON-SA Account.

if the job owner is sysadmin fixed server role step will be executed under the account used by the Sql...

yes, actually it is my next Simple-Talk article and I am showing hot to send an email too, and you can use Powershell for this 🙂

#SQLServiceStop

$query = "select *...

Maybe security context ?

Wen you run a Powershell sql agent job, the security context is the SQL Server Account (if the job owner is SA)..so take a look if the...

Have you tried :

(invoke-sqlcmd -serverinstance sqlserv -database playground "exec dbo.myproc" | select column1,column2 | ConvertTo-Xml -NoTypeInformation).save("c:\temp\teste.xml")

Hi Andrew, I believe it is a best scenario to use powershell. Take a look in get-service cmdlet or bing "service running powershell" you will find a lot of examples...

Hi Andrew,

I did something some time ago to my old company, but is using Powershell. If you are interest, this is the link 🙂

http://www.simple-talk.com/sql/database-administration/exceptional-powershell-dba-pt1---orphaned-users/

Hi rnunez,

I have tried this for a long time. According to the help of invoke-sqlcmd

Invoke-Sqlcmd does not return message output, such as the output of PRINT...

Great 🙂

I used messages and out-file just to format the text ...

Glad to help 🙂

I did not think much on how to join the output of sqlcmd with powershell, but there is a possible solution made in powershell for everything (not test with the...

I dont Know if I understand , But If you want to capture the output from sqlcmd to txt file, you can use the -o from sqlcmd..but in powershell you...

Hi,

I really do not understand your question, can you explain better ?