Accessing Linked Server in SQL Server 2000 (Urgent)

pts.
Tags:
Administration
Availability
Backup & recovery
Biometrics
Digital certificates
Identity & Access Management
Migration
MySQL
Performance/Tuning
provisioning
Security
Security tokens
Servers
Single sign-on
SQL Server
SQL Server 2000
Standard Edition 2000
Tech support
I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as 'linkedserver'. Again I added a linked server in 'SRVMAIN' as 'linkedserver'. When I write a query as SELECT * FROM linkedserver.TESTDB_new.DBO.TESTTABLE_new I get an error message: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ''. As linkedserver is an existing database, I cannot drop and rename it. It has huge amount of real data. Pls help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi All this is bakash again
The secon server is linkedserver. I missed ” in my previous question. Sorry
pls help thanks

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • swede27410
    I think you problem is that your linkedserver name is linkedserver. The linkedserver name can be anything that you wish. Having special characters in the the name does not require it to be enclosed in brackets. The only time you need brackets is when you have spaces in the name. Our linked server names are in the form of servername_databasename (ex. server01_database01).
    0 pointsBadges:
    report
  • Mejohnson
    check out openquery... SELECT * FROM openquery(LNKDSRVR1, 'select * from TESTDB.DBO.TESTTABLE) testtable Me Linda
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following