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)

What is use of @@ spid in sql server?

0 Answers  

---

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

---

What is dbcc? Give few examples.

0 Answers  

---

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

---

What is the difference between a view and a stored procedure?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

how many type of indexing in database?

0 Answers   IBM,

---

What is 5nf in normalization form?

0 Answers  

---

explain different levels of normalization? : Sql server database administration

0 Answers  

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---