Sorry for that.

Apparently I posted the wrong version.

Constraints should be using 'with check' for the obvious reasons.

maybe this attached sproc can get you started.

its goal is to generate a sequence of drop fk, convert pk 2 clustered, create fk encapsulated into a transaction per pk.

Actual...

that would be to much if it isn't needed for that user to actually read the data.

Shouldn't the login have been granted dbaccess any way ?

Why would you always want your primary key to be clustered ??

You should first check if your table has a clustering index.

I would also pay attention to the composition...

Did you have a look at the sqlserver Errorlog files ?

You can use SSMS to do so or import them and query on using sp_sys.sp_readerrorlog

If you are defining "failover" as...

-Please post your target table DDL ( including constraints and indexes )

did you try this ?

INSERT INTO dbo.VRWATSYSTABLE

SELECT distinct *

FROM [ZAVRCICAHS1].[Environmental].[dbo].[EnviroTable] Src

where not exists ( select 1 from dbo.VRWATSYSTABLE Trg...

I just...

Perry Whittle (2/7/2012)

---

You're pretty much limited with your current config. SQL Server 2008 R2 Express edition may be one way of overcoming this. There's no log shipping or mirroring but...

This is how we check if the db is available:

if exists ( select 1

from sys.database_mirroring

Where ...

So you implemented partitioning to overcome a rebuild problem.

Did you align indexes ?

If not, you end up practically in the same situation with regards to rebuilds.

If you did align...

- are you monitoring dbmirroring events ? If not, you should implement that ! (see attachments )

Your default trace file(s) may also help you to diagnose this issue !

Missed that tiny detail ... :blush:

source = R2 , target = sql2008

My guess is you are stuck to the "classic" replication ways using articles to publish and subscribe. (selecting individual...

CraigIW (2/6/2012)

---

ALZDBA (2/6/2012)

---

as always, it depends 😉

- Can your need be solved using backup ( of prod ) and restore ( to report env ) ?

( one should...

as always, it depends 😉

- Can your need be solved using backup ( of prod ) and restore ( to report env ) ?

( one should be able...