I am indeed

We do apply it to test at first and know that it is going to break replication. The ERP releases are more important than the work required to fix...

Ah right, thanks

ok cool thanks, that is what I was roughly going to do so thanks for confirming.

does the same go for updates?

So I did, google not my friend today am afraid.

Hi and thanks. Unfortunately I am using SQL 2005 and this view doesn't seem to be supported grr...

OK I have found this view sys.dm_db_persisted_sku_features however I am wanting to downgrade form SQL 2005 Ent to Std as such it does not exist.

Thanks for the replies - fair enough a bit of work required but should be ok. What is the best way to determine if the existing SQL Server is...

Hi again

Just to add to this it looks like we won't be going with Enterprise for AG as its too expensive, in which case we will have to use mirroring.

I...

OK thanks Gail, we have fired something off to our account manager but I sometimes find different companies get different answers, was just after some real world experiences which you...

GilaMonster (7/29/2012)

---

If the principal and mirror are in the same data centre and the entire data centre goes offline then the mirror has to be brought up manually because it...

Its multi site with no shared storage so I don't think that would be possible.

Hi thanks for the replies.

So there would be some manual intervention involved in certain scenarios, but I think they are something we could live with.

I am actually hoping we could...

I am talking about adding a group to the Sysadmin server role, which I did at installation time. I can see the group in AD contains my user and...

Hi - so the user does have permissions to query tables and sys.objects, however the list of tables does not appear in SSMS. How can I get this list...