What if i have N and Q as values in a column in old table and i want N as 1 and Q as 0 in the new table.What i...

When i tried servr -c -f ,i got error

"Your sql server installation is either corrupt or has been tampered with(SQL Registry Version Not Same as Server)Please uninstall then re-run...

Thanks 🙂

The application is showing disk full error.

CAn anyone please explain what is -c and -f ???

When i disabled that particular login for which the error occuring,the server

is working properly and no error is reported so far....:crazy:

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???