Answer / Krishna Murari

To drop a user in SQL Server who owns SQL objects, follow these steps:
n 1. Take Ownership of Objects: First, transfer ownership of all the objects owned by the user to another user (preferably sa or dbo) using the T-SQL command ALTER OWNER.
n 2. Drop User: After successfully taking ownership of all objects, you can drop the problematic user using the DROP USER command.

Name the different type of indexes in sql?

1 Answers  

---

Is the order of columns in the set clause important in ms sql server?

1 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

How to execute stored procedure and set temp table in sql server?

1 Answers  

---

What security features are available for stored procedure?

1 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

1 Answers  

---

What is enhanced database mirroring in sql server 2008?

1 Answers  

---

Write the SQL query to drop, truncate and delete table.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What is database architecture? : SQL Server Architecture

1 Answers  

---

What are the steps you must follow to hide sql server instances?

1 Answers  

---

What happens if null values are involved in datetime operations?

1 Answers  

---

what is a deadlock? : Sql server database administration

1 Answers  

---