Answer Posted / anil sharma

In sqlserver 2000 we must use a unique id per row then we
can delete duplicate rows.

delete from <tablename> where <rowid> not in (select min
(<rowid> from <tablename> group by co1,col2.)


But in sqlserver 2005 there a function RowId.Which is same
as above concept.It return unique id per row.

What are the differences between clustered and non-clustered index?

954

---

What is the difference between push and pull subscription? : sql server replication

1149

---

what is the primary use of the model database? : Sql server administration

962

---

What does asynchronous call backs means?

1071

---

How to generate create procedure script on an existing stored procedure?

937

---

How to add a new dsn with the odbc driver for sql server?

1009

---

Why variables called the most powerful component of ssis?

1026

---

What is stretch database in sql server?

1026

---

Can sql server be linked with other servers like oracle?

903

---

what kind of lan types do you know? : Sql server database administration

924

---

How does a profiler work?

870

---

Define primary key?

1077

---

How is a full-text index updated?

896

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1971

---

What are the different authentication modes in sql server? How can it be changed?

1023

---