Abhay

If I had to put money on it, I'd say that your tables aren't owned by dbo.  You've confirmed that both tables are owned by the same user, and you've...

Abhay

Does this work?

USE QISPD

Insert Into QISPD2.dbo.VisitInfo (VisitId, patientId, admitDate, VisitType, spotriasUniqueId)

Select visitId, patientId,...

Mark

Are you doing this on a production sever?  Have you tested it first?

There are certain things to look out for.  For instance, I think SP4 limits the pairs of data...

Abhay

I don't really know.  I take it both databases are on the same server?

Do you get the same error if you just do this? SELECT * FROM QISPD.dbo.visitInfo

What...

Abhay

So it sounds like visitInfo doesn't exist in QISPD, or if it does it's not owned by dbo, or maybe you don't have permissions on it.  Or perhaps you have...

Abhay

Assuming both abc tables have an identical structure and are owned by dbo:

INSERT INTO QPR.dbo.abc

SELECT * FROM XYZ.dbo.abc

John

Have you tried sp_helprolemember?

John

The order of the rows in a table has no meaning in a relational database system.  Does your table have a primary key constraint?  If so, you can order by...

"I don't know why management studio only shows fisical drives, and not mapped drives"

I imagine it's because the drive is mapped in the context of your login and not in...

Happycat is right - backing up and then restoring to a different location is the best way.  However, I don't think detaching and re-attaching will work, since I believe this...

Adrain

Right-click on your server in Enterprise Manager and choose Properties.  The server collation appears on the General tab.

John

Certainly not the best way of doing it, Anders, but since you and I have both asked how he decides which duplicate rows to keep and haven't had a proper...