Apologies, I missed the enable in step 9...I'd just skimmed the article. None of the code in the article references the OA objects...maybe one of the other articles objects...

Yes, there are security issues to consider with allowing use of the OA procedures. If your users have means to execute code at an administrator (sa) level, then they...

This is what I've been using to send email via Powershell:

$sender = "SQLAgent@FooServer.MyCompany.com"

$recipient = "24x7DBA@MyCompany.com"

$server = "MYSMTP.SERVER"

$file = "Foo.txt"

$subject = "Sending Foo.txt at " + [System.DateTime]::Now

$body = "Foo Report"

$msg =...

You're fine with that output. You want to rerun sp_configure and check the run_value column to ensure it's set to 1 for the options you just turned on. ...

Actually,...

You only need to set the advanced options once.

Change your reconfigure to RECONFIGURE WITH OVERRIDE;

Well, there are tricks to echo the dynamic sql to file, but then you have filesystem maintenance to include in your process(es) as well....

Other than the file trick, I think...

One thing to bear in mind regarding the default/blackbox traces, is that they have a low file-rollover threshold and on busy systems, may only show very short windows of activity...

It's...

Is using a file to hold the query to execute, and then use -i instead of -Q an option for you?

Instead of doing a cmdline query, you can save the...

Interesting, thanks for the information, Tommy.

I wonder what a poll of who does vs. who doesn't, would show?

However, 3159 is the last public cumulative rollup (without having to request the hf specifically from MS)...

How many of you do contact MS for these pss-only oriented cumulative rollups (not...

Make sure you disconnect from the server...

-- Disconnect from the server.

EXEC @hr = sp_OAMethod @object, 'DisConnect'

IF @hr <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT

...

To alleviate some of the snapshot reads occurring on the source database, you can use mirroring to extend the architecture out.

ProdDB ----> MirrorDB ----> Snapshot.

By taking snapshots of the mirror...

That it's time to re-install SQL Server on that machine.

I seriously hope that these are joke posts.

These failures of large network backup operations (restores can suffer the same issue if being done over the network) are usually due to running the target server out of kernel resources...