Thanks

tempdb.mdf and templog.ldf files is located on my C drive as below.

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2008\MSSQL\DATA

I have 10gig free space on C drive and I have 3 gig RAM on my...

thanks

I uesd store procedure as advice my above. But I am still getting this error;

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)

[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar...