Transfer of data between tables in different databases on same server

[T Arrowood]

When executing an inline insert into command from isqw/w the command executes perfectly. Yet when I try to create a stored procedure with exactly the same insert into statement it will not create. It does not like the database.owner.table prefix on the selected rows. Any suggestions ??

Thanks.... Tom

[Kevin Miller]

Tom, send me your SQL statement and I'm sure I can help you.


------------
T Arrowood at 6/22/99 9:30:43 AM


When executing an inline insert into command from isqw/w the command executes perfectly. Yet when I try to create a stored procedure with exactly the same insert into statement it will not create. It does not like the database.owner.table prefix on the selected rows. Any suggestions ??

Thanks.... Tom