thanks for quick replies.

Able to resolve the issue. Applied patch SQLServer2005 SP4 on my RTM. Now its working fine.

Thanks you all

DECLARE @ColumnListNVARCHAR(MAX)

SET @ColumnList =''

SELECT@ColumnList= @ColumnList + CAST(COLUMN_NAME AS VARCHAR(128)) + ', '

FROMINFORMATION_SCHEMA.COLUMNS

WHERETABLE_NAME = 'MY_TABLE'

ORDER BYORDINAL_POSITION

IF LEN(@ColumnList) > 0

SET @ColumnList = LEFT(@ColumnList, LEN(@ColumnList) - 1)

PRINT @ColumnList

The above piece of code works...

Hi this is the correct piece of code. I missed AS BEGIN in view definition.

DECLARE @sql varchar(max)

SET @sql='

USE '+@Database1+'

IF EXISTS (SELECT 1 FROM SYS.VIEWS WHERE...

Hi all,

I had a database backup database1.bak in one server and i need to restore it to some other database in a different server.

I dont want to copy the database...

nchar(222) or char(222) is Þ.

How this is replacing th. Moreover th is two characters and above one is just only one character.