Koen Verbeeck (9/12/2013)

---

Still not 100% sure what the problem is - screenshots would be nice - but I'm getting a hunch.

CSV is a simple plain text file. Since carriage returns...

Hi Koen

Thanks for reply. Apologies for vague question. The...

MickyD (9/12/2013)

---

Morning everyone.

I have a query that works ok , and uses msdb.dbo.sp_send_dbmail to send the results.

The results in .csv look terrible.

Can anyone recommend anything to format the results ?

Query...

schleep (8/28/2013)

---

A web search using the words "Services Powershell Status" leads to the following:

get-service -name "MSSQLServer" -Computername TargetServerName

Which returns

Status Name ...

george sibbald (8/22/2013)

---

sounds like you are missing a log backup. Check the databases backup history from the backupset table in msdb on the primary. If there are missing log backups...

Once again , perfect thank you.

Perfect thank you.

I have the mail profile etc all working.

Do you know how I would generate the output as a .csv and not a .txt ?

Perfect thanks Luis.

Chris

Many thanks for your quick response appreciate it.Works great.

Final question I have is , how would you amend the script to write to the same table again. So it can...

opc.three (7/24/2013)

---

You cannot send output to the Out-Host when using a PowerShell step type. Long story, but PowerShell steps in Agent 2008 are not full shell. In Agent 2012 the...

Hi Gaz

thanks...

Gazareth (7/22/2013)

---

Bit of a guess, but permissions issue? Presumably the ISE is running under your credentials whilst the SQL Agent one will be the SQL Agent account.

Is the job targeting...

Lrobinson 93181 (6/18/2013)

---

Ok, I now see that the "Desktop" file workaround fixes a "save as" exception, and my exception occurs when opening the Excel file. I am going to...

thanks , I will check and report back

Hi Joie

Yes excel is installed on the machine. I am running SQL 2012 on the machine and Excel is on there as well.

Still learning PS so any advice is welcomed.

This...