Thanks for the Reply,

...

Hi,

If the structure in 2005 is same then use backup and restore.Then change the compatability level to 90.Run dbcc checkdb on database.Before that script out all...

I expected the same and checked the date and time,no hope.Date and time or the server is the current date and no issues with the same.Persently we are restarting the...

Check this for difference between 2000 and 2005

http://www.sqlservercentral.com/articles/Administration/2988/

Try restoring the database in single user mode

Please find the attachment.

Hi ,

I did the same but the problem is that the csv i have is extracted from peoplesoft database and contains...

Hi Andras,

THANK YOU VERY MUCH FOR THE REPLY

Now my problem is that i...

How to change the collation of table and rows seperately???

If you are search for backup files then also give .dmp in your search criteria..

Thanks Vidhya

What you mean by common column??

Try using

xp_cmdshell 'netstat -an'

xp_cmdshell 'ipconfig /all'

Thanks for the information GILA

Shrink tempdb.Thats the only way to get rid of this