Re: To retrive a table from one database to and another database(same table)

From: "Jens" <Jens@xxxxxxxxxxxxxxxx>
Date: 17 Mar 2006 03:02:02 -0800

Hi,

use the three part notation:

SELECT * FROM database.owner.Objectname

(replace owner by schema for SQL2k5)

HTH, Jens Suessmeyer.

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

.

References:
- To retrive a table from one database to and another database(same table)
  - From: surya

Prev by Date: To retrive a table from one database to and another database(same table)
Next by Date: Re: Alternative to OpenXML
Previous by thread: To retrive a table from one database to and another database(same table)
Next by thread: Re: To retrive a table from one database to and another database(same table)
Index(es):
- Date
- Thread

Relevant Pages

Re: Spaltenberechtigungen abfragen
... fibt es die Tabelle syspermissions dafür, im SQL2k5 ... HTH, Jens Suessmeyer. ... Prev by Date: ...
(microsoft.public.de.sqlserver)
Re: Mit in Variablen gespeicherten Datentypen weiterarbeiten
... >> Hallo Henry, ... >> HTH, Jens Suessmeyer. ... Next by Date: ...
(microsoft.public.de.sqlserver)
Re: Hilfe, kein Zugriff auf SQL-Server mehr!
... > SQL-Server existiert nicht oder Zugriff verweigert. ... >> HTH, Jens Suessmeyer. ... Next by Date: ...
(microsoft.public.de.sqlserver)
Re: Hilfe, kein Zugriff auf SQL-Server mehr!
... Wenn ich an einen anderen Computer gehe und mich mit sa einlogge ... >> HTH, Jens Suessmeyer. ... Next by Date: ...
(microsoft.public.de.sqlserver)
Re: MSDE newbie
... The problem is that there are spaces in the pathname, ... >> You did not specify th instance you want to connect to, ... >> HTH, Jens Suessmeyer. ...
(microsoft.public.sqlserver.msde)