I thought the changeowner sp was deprecated.

I use a date column that changes regularly and compare that across the replication partners;

SELECT

MAX(LASTHANDLINGDATE) AS Source_LASTHANDLINGDATE

FROM [Source]

GO

SELECT

MAX(LASTHANDLINGDATE) AS Dest1_LASTHANDLINGDATE

FROM Dest1

GO

SELECT

MAX(LASTHANDLINGDATE) AS Dest2_LASTHANDLINGDATE

FROM Dest2

GO

Thank you, I just had to do that, it worked for me as well.

I played with all the scripts on this page and have looked before for something like this. This is beautiful.

Do you have the mas90 driver installed on your laptop?

Cool, I've never seen datacenter.

The parteners need to be on the same edition of SQL Server.

Best practices is to not enable the SA account at all, unless you actually need to use it due to your environment (non-Windows clients, legacy apps, etc). If you are...

I believe the 'trusted connection = yes' implies that the connection is be made using Windows authentication and is whatever account is used to logon.

Based on your setup, as a start, I would set my minimum and maximum SQL memory to 6GB, this leaves 2GB for your OS, then give the SQL Server service...

You would use the extension you give your backup files without the "." IE. bak or trn. You will also have to create a step for each different extension you...

I'm curious why you're doing this in C# and not just using the interface in SSMS?

Do you see anything in the SQL logs like this:

The mirroring connection to "TCP://myserver.mydoamin:5022" has...

You don't go into specifics about you setup but,

From:http://msdn.microsoft.com/en-us/library/ms366349(v=sql.90).aspx

On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the...

Howard C. BAchtel-438731 (2/15/2011)

---

We are planning to move from 2005 to 2008 SQl Server (different/newer server). Our plan is to do full backup of all user databases from 2005...

Why not turn the view into a table sql 2000

select *

into tabletocopy

from viewwithdata

 

Ralph