Answer / Chitrasain

To change a login name in MS SQL Server, you can use the 'sp_renamedlogin' stored procedure. Here is an example:nn```sqlnEXEC sp_renamedlogin '<old_login_name>', '<new_login_name>';n```

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

What is the user of Primary key?

1 Answers  

---

What do I need to start working with sql studio? : sql server management studio

1 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

1 Answers  

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

what is the difference between delete table and truncate table commands? : Sql server database administration

1 Answers  

---

Explain trigger and its types?

1 Answers  

---

How to concatenate two binary strings together?

1 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---