has the user been added as an explicit server login on the sql server.

What are the resultsd of the following query

select name, SID

from sys.server_principals

where type = 'U'

and...

uninstall the cu and reboot then try re applying

In that case you use CREATE INDEX specifying the new file group with the DROP_EXISTING = ON clause

See here for more detail

No problem, don't forget to check the pre reqs and restrictions carefully, it can save you a whole lot of time later on.

Google??

Does the PK have a clustered index upon it at present?

yes but i'm assuming you'll have other databases that are not part of the AO group or even other instances that may use DTC, if you don't then don't worry....

yes you could argue that....

Yep, MSDTC has absolutely nothing to do with SQL Server,...

DC?

It's a consideration, yes.

SQLSACT (4/16/2013)

---

Doesn't this take away from...

SQLSACT (4/16/2013)

---

Hi All

My Setup:

>> 3 Servers (Node1-Node2-Node3) all part of the same Cluster "Cluster1"

>> SQL installed as clustered on Node2 & Node3, producing "SQLCluster"

>> SQL installed as nonclustered on Node1,...

JayK (4/15/2013)

---

Hi Perry,

Thanks for getting back - in reality I just need to check that data in a single column is the same for each matching PK in the 2...

tsdsuresh (4/15/2013)

---

Hi All,

I have set up logshipping between server A (Primary) and server B (Secondary), and tested log shipping by activate database from server B ( Stop the log...

check results of the following query both before and after the drop

SELECTOBJECT_NAME(i.object_id) AS TableName

, ISNULL(i.name, 'HEAP') AS IndexName

, i.index_id as IndexID

, i.type_desc AS IndexType

, p.partition_number AS PartitionNo

, p.rows AS NumRows

,...

Interesting one this, there is a known issue around the removal of LOB data in sql server. Dropped LOB data is not removed immediately, there is a ghost process that...