dbo.syscolumns and sys.columns are two different...

Here is a good blog entry from Kimberly Tripp explaining in detail the issues caused by using UniqueIdentifiers as your clustered index:

http://www.sqlskills.com/BLOGS/KIMBERLY/post/GUIDs-as-PRIMARY-KEYs-andor-the-clustering-key.aspx

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125318&wa=wsignin1.0

TRACEY (4/15/2009)

---

select * from

DBO.TRACEY_HOLD_POOL_BASE_ACCT A

INNER JOIN DBO.EXCEL_POOL_BASE_ACCT B ON

A.FY_CD = B.FY_CD AND

A.POOL_NO = B.POOL_NO AND

A.ORG_ID = B.ORG_ID AND

...

Sharon Levine (4/15/2009)

---

Many of the tables in our database use triggers, so I thought I'd use SCOPE_IDENTITY() to return the proper identity value. Imagine my surprise when I create...

I've seen this problem come up when I was dealing with sql 2000 transactional replication. For me, it didnt cause a problem until an update or delete needed to...

I believe you'll have to either reinitialize the snapshot or manually insert the missing record on the subscriber to get it going again.

If the column "ID" is a primary key or unique key in the dbo.ABC table, you can create foreign keyes with "ON DELETE CASCADE" that references the ABC.ID column from...