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
---

[Back to original message]