Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Duplicate Records...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-03-30 : 08:43:29
Ruchir writes "Dear Sir,

I want remove duplicate records from a SQL server 2000 runnning online so that i can't rename the database as well as i can't rename the table because it will stop the online process for some time so i want a easy to use method to eliminate duplicate records from a online sql server 2000. I can't change the database.
Please Reply me soon.

Regrads,

Ruchir"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-03-30 : 09:46:04
Do a search on the forum for duplicate records. There have been some great posts about this already. You should be able to get a script from that.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -