MS SQL Server :: SELECT Rowguidcol From Tables On Linked Servers?

Select Into Across Linked Servers

Sep 28, 2007

Hi. I'm trying to copy from one table to another across 2 differentservers with the following:select *into #Tmp_Hdrfrom parsaleshdrwhere businessday = '9/20/07'select *into [pdsqla01pdsqla01].impact_exec.dbo.parsaleshdrfrom #Tmp_HdrThis gives me an error:The object name 'pdsqla01pdsqla01.impact_exec.dbo.' contains morethan the maximum number of prefixes. The maximum is 2.Not really sure how to get around it. I was trying to use OpenQuery,but that's really for selecting from, not into. How can I get aroundthis?Thanks,Jennifer

View 1 Replies View Related

Question About Linked Servers And Access Tables

Jan 7, 2005

Having a little problem with linking to Access tables. I have an Access database that has in it, some linked tables. After setting up the linked server in SQL server, none of the linked tables in Access show up, only the tables that were created or imported show up.

Is there anything you can do to get the linked tables in Access to show up under the tables list in the SQL linked server?

View 3 Replies View Related

Linked Servers: SELECT * INTO Doesn't Work

Sep 21, 2001

I administer several servers. My login is a SysAdmin on all servers with not only the same Name and Password, but also the same SID. In setting up Linked Servers, I can successfully SELECT data from a server other than the host server, but if I try to SELECT * INTO I get the following error:

The object name 'DB1.ogSerial.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

Here are the queries I've tried (using DB3 as the host, DB1 as the linked server).

SELECT * INTO DB1.MyDB.dbo.TestTableNew FROM DB3.MyDB.dbo.TestTable
SELECT * INTO DB1.MyDB.dbo.TestTableNew FROM DB1.MyDB.dbo.TestTable
SELECT * INTO DB1.MyDB.dbo.TestTableNew FROM MyDB.dbo.TestTable

View 3 Replies View Related

SELECT Rowguidcol Vs. SELECT &<actual Name&>

Apr 11, 2008

I understand that I can do this is SQL Server:

CREATE TABLE dbo.test1 (
Col1 int IDENTITY,
ColGUID uniqueidentifier rowguidcol NOT NULL CONSTRAINT DF_test1_ColGUID DEFAULT NEWSEQUENTIALID()
)

INSERT INTO dbo.test1 DEFAULT VALUES

SELECT rowguidcol FROM dbo.test1
SELECT ColGUID FROM dbo.test1

I get this result:

ColGUID
------------------------------------
ED2D1EF0-0408-DD11-A8EB-001AA0D389DB

ColGUID
------------------------------------
ED2D1EF0-0408-DD11-A8EB-001AA0D389DB

Here's the question: Is there any performance difference between using the actual column name and "rowguidcol"?

I would like to be able to script a trigger that uses the rowguidcol column. If I could use rowguidcol instead of the actual column name, I would not have to hard-code the column name in the trigger.

Thanks,
Rob

View 9 Replies View Related

Select Data From Diff. Tables On Diff. Servers

Feb 12, 1999

I need to write a 'select' statement to fetch data from different tables, which are located on different servers.
Can any one help in writing this 'select' statement with out moving the tables on to same server.

Thanks in Advance.

Murali Raparla.