We made a clean cutover to PowerShell when we migrated to SQL Server 2008 a year ago because PowerShell was Microsoft's latest vision of the future. We are a "locked...

I do as well. I primarily use PowerShell to lauch scripts that contain calls to SQLCMD.EXE. In our environment, Task Scheduler is just way easier to manage than a bunch...

I opened a call with Microsoft. They tell me that there is no way to move $pshome in Windows 7 Enterprise and presumably Windows Server 2008. It functions as designed....

Hmmm. Sounds like that would work for batch jobs, but I would like something that would handle interactive commands too (so I can test in the exact same environment...

FYI -

I found this reference on page 2333 (i.e., on the CD-ROM) for "Microsoft SQL Server 2008 R2 Unleased," copyright 2011, SAMS Publishing:

"Also, you need to remember that log shipping...

That link does not work for me.

By the way,...

This works. It turns out that the New-Variable command does not use a dollar sign ($) with its "-name" parameter; so, I had to parse that out. See below.

# This...

This seems to work without killing the batch.

raiserror ('test', 0, 0) with log;

Thanks for the tip, Gail!

Hmm. I hadn't thought about RAISERROR. Won't that kill the current batch too though?

PHXHoward (12/20/2010)

---

This blog article shows how to script multi server queries through PowerShell that can be scheduled as a SQL Agent job. Unfortunately, outputing to the PowerShell window is not...

No, I haven't. Theoretically, you should be able to load the server names into an array and bump through each element in the array with a sqlcmd.exe statement, but I...

Hmmm... That's interesting. I didn't know about that. Thanks for the tip. I definitely need to check that out.

Here is a bit more detail...

As I built our SQL Server 2008...

MysteryJimbo (10/11/2010)

---

There's no way of doing it through management studio.

I accomplished this by using powershell and combining multiple resultset along with @@SERVERNAME into a $variable and pinging a HTML email...

Thanks for the feedback. This has been a nightmare. The Data Domain vendor sent me a PDF file which said that its product can be easily integrated with Active Directory...

FYI -

A coworker found this link:

http://blogs.technet.com/b/askds/archive/2008/09/29/command-line-compression-in-core.aspx

It appears to be sychronous, but its compression is not as good as zip. MAKECAB shrinks a 200 MB file to 10 GB, where zip...