RE: looking for ways to list publication object please help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Paul Thank you for your response

I ran the first statement

select name from sysobjects
where id not in (select objid from sysarticles)
and xtype = 'U'
and objectproperty(id, 'ismsshipped') = 0

return with the following error
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sysarticles'.

the second statement

select name from sys.objects
where is_published = 0
and is_ms_shipped = 0
and type_desc = 'USER_TABLE'

I receive 1 colume

Thanks


"Paul Ibison" wrote:

One of these queries below should be what you need:
HTH,
Paul Ibison, www.replicationanswers.com

-- SQL Server 2000, 2005 and 2008
select name from sysobjects
where id not in (select objid from sysarticles)
and xtype = 'U'
and objectproperty(id, 'ismsshipped') = 0

-- SQL Server 2005 and 2008
select name from sys.objects
where is_published = 0
and is_ms_shipped = 0
and type_desc = 'USER_TABLE'
.

Relevant Pages