How to delete exactly duplicate records from a table?

0 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---

What number sorts of privileges are accessible in sql?

0 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

Which autogrowth database setting is good?

0 Answers  

---

---

What do you mean by acid?

0 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

Where do we use trace frag?

0 Answers  

---

What is bcp? When does it used?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---