The suggestions are NOT 100%. They are suggestions. Quite often, they are dead wrong. Sometimes they are quite good.

You'll need to review the suggestions and make sure...

Try making the command be:

rename C:\Inetpub\wwwroot\Pergamum\Doc\International Banking\Caribbean Caribbean11

Thanks for the replies. Just wanted to make sure I wasn't doing something wrong. (My first time playing around with mirroring.)

Please don't double-post in multiple forums.

You should be able to query that recordset and get the max value.

create table dbo.SelfJoin (

ID int identity primary key,

ParentID int null references dbo.SelfJoin(ID))

That's a self-join (one type, anyway). It's just a table that joins to itself.

Glad I could help.

A lot of it will depend on your data structure (tables), indexes, etc.

Another important question is whether the reports need to be real-time, or if they can be cached in...

I just did this as a test:

create table UpdT1 (

ID int identity primary key,

Col1 varchar(100))

go

create table UpdT2 (

ID int identity primary key,

Col1 varchar(100))

go

insert into dbo.updt1 (col1)

select 'x'

from dbo.numbers

insert into dbo.updt2...

Not sure it can be done from QA. Might be able to do it from Enterprise Manager. Not sure. Maybe if you ask in the SQL 2000...

In the second part of CTE2 (after Union All), change "c3.valset" to "c3.date". That should give you what you need, regardless of the number of dates in a row....

You can do that with CTEs (Common Table Expression). They can be recursive.

Not sure why it would give you an invalid column name. I'll test it.

Apex Diff should give you a synchronization script. You're going to need to break it down into smaller chunks. Just run a few thousand rows at a time.

I just set up a mirror on one of my proof of concept databases, then truncated a table (that did have rows in it), then did a failover on the...

I didn't have time to test this, but give it a shot and tell me what's broken, and I'll have time to get back to it in a little while.

;with...