SELECT 'EXECUTE AtashSooziFloorInsert ' + CAST(AtashSoozId as varchar(100))+ '

CASTFloorID as varchar(100)) FROM ImportedTable

then you can execute this list of sql

or you write a cursor and then execute all sql

It is true i didnt look at that

test make in the same server only instances are diffrent

tHANKS FOR LINKS AND HELPSSS

Am I waiting SQL SERVER 2008 R2 SP2 CU1?

All backup have the same problem.

How can i merge production db and backup in sys.objects ?

This is correct my friend

Restore database dosen't solve this problems

because backup of database involve system tables of

database This the main problem query

SELECT * FROM SYS.columns CLM WHERE CLM.OBJECT_ID

NOT IN (SELECT OBJ.object_id FROM...

This is the solution but i am going to try it

http://sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Using-the-SQL-2005-Dedicated-Admin-Connection-to-fix-Msg-8992-corrupt-system-tables.aspx

DBCC CHECKDB give this error

Server: Msg 8939, Level 16, State 5, Line 1

Table error: Object ID 0, index ID 0, page (1:288). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.

Server: Msg 8939,...

Oke i will try it...

It is oke but LOGICALREF is an clustered index column i can why it is suggest that?

/*

The Query Processor estimates that implementing the following index could improve the query cost by 99.9906%.

*/

/*

USE [DB]

GO

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]

ON [dbo].[TBL] ([STOCKREF],[INVENNO],[DATE_])

INCLUDE ([LOGICALREF])

GO

*/