I mean to say, the query which you given for 8000+ width gives error on Both version of 2005/2008. do you have other solution?.

SQL Server 2005 v9.0 SP4----

Msg 103, Level 15, State 1, Line 1

The character string that starts with '

SELECT TOP 1 [EmployeeKey],[ParentEmployeeKey],[EmployeeNationalIDAlternateKey],[ParentEmployeeNationalIDAlternateKey]

' is too long....

My answer is ERROR

as insert query given me error. moreover yes Rollback can rollback pages truncated by TRUNCATE.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ','.

Thanks