Posted by Jens on 10/01/22 11:43

Hi,

use the three part notation:

SELECT * FROM database.owner.Objectname

(replace owner by schema for SQL2k5)

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

• Next in forum: Re: bcp right truncation: how to ignore
• Prev in forum: To retrive a table from one database to and another database(same table)
• Thread view: Re: To retrive a table from one database to and another database(same table)

[Reply to this message]