Thanks. Will look forward to a good read 🙂

Did you recently use the config manager to move any databases around?

Is the MSSQLSYSTEMRESOURCE database still available (usually in the DATA directory).

Check on the status of the flat file db's...

I'd shut down sql completely and simply immage (clone the disks) over onto your HP disks. Any differences should hopefully be handelde by the underlieing san os.

GilaMonster (12/7/2009)

However I have a policy whereby I do not answer questions...

That might work!

http://msdn.microsoft.com/en-us/library/ms151329.aspx

Hmmm, when its changed, is that to add a conutry (which will add a foreigh key) or just to modify some data?

You dont have t o replicate all columns in...

What you have suggested (SISS package) does seem to be a logical way round your issue (if a bit long-winded). Is this 'CountryTable' the only excception? Cause if there are...

In that case, sorry no. I dont know of any.

SQL2008 (and 2005 in a limited fashion) have the security policys that can goven thing like naming conventions etc, but that...

Jason is absolutely right. Under no circumstances allow them to do this. Firstly them saying they always run on their own SQL iinstance is rubbish and more likely a revenue...

What do you mean 'code reveiw'? A Tool cant tell you if your code will do what you want, it doesnt understand your business or its needs.

The best any tool...

How does the 3rd party app connect?It could be as simple as a service account.

When you say you gave all domain users 'admin', what does that mean? DBO to...

So your replicating your production to then trigger your replica to then populate your hybrid.!?

Sounds a bit long winded. Obviously you cant test this stuff in production, but this is...

Just so I understand, you are essentially trying to take data from one db and synchronise it with your hybrid? If i'm right I dont think replication could ever have...

This might be a stupid question but are you running the SQL 2008 client?

I have found that for some reason, a SQL 2005 Ent 64-bit cluster state cannot be seen...

Huh?

Please re-phrase your question as it made no sence.