Mirroring is HA, replication is data distribution.

In P2P replication you have no primary/secondary or principal/mirror relationship between nodes.

I highly discourage that approach.

I would focus on the main problem: rebuilding indexes.

Why...

You're right. Peter Larsson (swePeso)...

Some other options:

1. Create a SSIS package using the Fuzzy Lookup Transformation[/url]

2. Normalize your address data using online services such as Bing Maps[/url]

Powershell will do the trick:

sl c:$qry = "

SELECT DISTINCT d.logical_volume_name

,d.volume_mount_point

,CAST(d.total_bytes / 1024 / 1024.0 AS INT) AS TotalMB

,CAST(d.available_bytes / 1024 / 1024.0 AS INT) AS FreeMB

FROM sys.master_files f

CROSS APPLY sys.dm_os_volume_stats(f.database_id,...

If you're on 2008R2 or 2012 you can use sys.dm_os_volume_stats to query disk information.

It would look something like this:

SELECT DISTINCT d.logical_volume_name

,d.volume_mount_point

,CAST(d.total_bytes / 1024 / 1024.0 AS INT) AS TotalMB

,CAST(d.available_bytes /...

You can find a description of SQL Server installation paths here:

http://technet.microsoft.com/en-us/library/ms143547(v=sql.90).aspx

Luis's suggestion is quite good, but please keep in mind that you won't get the exact sequence of the statements that way.

For instance, you won't get parameteres for parameterized queries.

If...

Add a powershell step to the job on server A that connects to server B and runs sp_start_job.

The powershell script would look similar to this:

Invoke-sqlcmd -ServerInstance "serverB" -Query "EXEC msdb.dbo.sp_start_job...

A couple of thoughts:

1. Your trigger is not safe, as it assumes only one row is processed at a time.

IF (SELECT LEFT(IDDOC,3) FROM INSERTED) <> 'CPX'

This will break horribly when...

You can't do that directly from SQL Server, nor I think that would be a good idea.

You need a thrid-party app (and a GSM modem, which I wouldn't plug to...

You don't need to do anything different from what you would do with a physical server.

Thanks for your help.

I understand the reason of this restriction, but it makes using impersonation a bit impractical.

I think that my only option is to keep using SQL Authentication and...

Timothy, thanks for your feedback.

I must admit I phrased it with rhetorical tautologies in mind and you're 100% right in your correction.

Paul, your answers could be collected in a book and it would be an absolute best-seller!

Awesome, as usual.

Interesting question.

Anyone?