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)

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

Why do we need normalization?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

How do you delete a trigger?

0 Answers  

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

---

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---