What should I do with syncobj in SQL Server

Posted by hgulyan on Stack Overflow See other posts from Stack Overflow or by hgulyan
Published on 2010-05-26T04:33:02Z Indexed on 2010/05/26 9:31 UTC
Read the original article Hit count: 379

Filed under:
|

Hi.

I run this script to search particular text in sys.columns and I get a lot of "dbo.syncobj_0x3934443438443332" this kind of result.

SELECT c.name, s.name + '.' + o.name
FROM sys.columns c
INNER JOIN sys.objects  o ON c.object_id=o.object_id
INNER JOIN sys.schemas  s ON o.schema_id=s.schema_id
WHERE c.name LIKE '%text%'

If I get it right, they are replication objects. Is it so? Can i just throw them away from my query just like o.name NOT LIKE '%syncobj%' or there's another way?

Thank you.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sysobjects