Answer / raghu_iteamic

exec sp_change_users_login 'Report'
Running the following query on destination server where
database as been moved to list orphan user

Answer / karthik

Orphan User : NO login id or password are not associated
with user.

exec sp_change_users_login 'Report' (It helps to find the
orphan user)

Exec sp_change_user_login 'auto_fix','loginname',null(It
helps to map the user with login)

Tell me what are the advantages of using stored procedures?

0 Answers  

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

What is the difference between deallocate cursor and close cursor?

0 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

what is extended StoreProcedure ?

3 Answers   Satyam,

---