on 04-02-2007 6:41 PM
I can see that TCPDB in sysobjects.
However:
select * from 'TCPDB'
ends up with:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'TCPDB'.
I try SID.sid.TCPDB also get the same eeror.
Please help. Points!
try this
select * from <sid>.TCPDB
no need for single or double quotes.
RT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
All the database objects in the <SID> database is either under SAP<SID> (ABAP stack objects it is SAPR3 in earlier versions) and SAP<SID>DB (Java stack objects). So any SAP tables has to be addressed using the schema prefix. If you are quering for SQL Server system tables then no need to do the schema prefix since these are under "dbo" schema.
I hope this answers your quesiton.
RT
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.