unfortunately i create table call 'sysmessages' in SQL Server 2008. when i restore the DB to SQL Server 2012 i realize that i have two Tables call 'sysmessages'.
i don't want to change my table name because it using in the code.
can i remove only from specific database system table?
select * from sys.sysmessages, you will address it like
select * from dbo.sysmessages
edit - no. 2. is not applicable in SQL 2012, however it is tested and working in SQL 2008R2