are you trying to delete the actual owner of the database?

I bet there's only 2 to pick from, if you can even find one. :hehe: BI books in general have been hard to come by since 2008...

try @body='your query here'

or create a variable and put the query result in @variable such that @body = @variable

or try: @attach_query_result_as_file = 0

sp_send_dbmail

I typically do something like:

DECLARE @tableHTML...

Another possible route is to make a CmdExec job step that runs a del cmd.

Looks like transactional replication to me

Log shipping is simply backup, copy, restore. You can have multiple secondaries, you just have multiple copy and restore jobs:

Log Shipping Overview

"The log can be shipped to multiple secondary...

If you want to monitor 1000 servers, then stop doing this manually right away. Get your boss to give you a budget and then invest in one of the many...

How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update

Did you perform failover during patching?

From what I'm seeing it may be related to the failover vs. the CU/Patch.

AlwaysOn Availability and TRUSTWORTHY Property

Learn Who Started that Trace with the Default Trace

slight mod:

DECLARE @FileName VARCHAR(MAX)

SELECT @FileName = SUBSTRING(path, 0, LEN(path)-CHARINDEX('\', REVERSE(path))+1) + '\Log.trc'

FROM sys.traces

WHERE is_default =...

VM +1

Are you asking about a failover cluster or an availability group?

Typically AGs are setup (as basically mirroring) between stand alone instances on top of WFC nodes, not clustered SQL instances.

HTH

Here's the only way I've ever seen that done, but it doesn't address db_datareader only or the group ownership

USE [master]

GO

CREATE LOGIN [test] WITH PASSWORD=N'test', DEFAULT_DATABASE=[TestDB], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

USE [TestDB]

GO

--DON'T Create the...

What are you trying to do exactly?

Here's some related links:L

Windows Server: Troubleshooting "RPC Server Unavailable" Errors

Connecting to remote SQL Server Integration Service from SQL Server management Studio[/url]

RPC Service not running...