Hello I am developing a VB application and my backend is MSSQL 2000.
I have 2 Database Say DB1 and DB2.Both are in Same Server.
Now i need to get data from DB1 and insert into DB2.
Eg.
Insert into tablefromDB1 Select * from ServerName.dbo.TableFromDB2
how can i do this with username
insert into tablefromDB1 select * from Servername.username.TablefromDB2
When i put like this it pops up a error.
Need help
with regards