CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Database >> Microsoft SQL Server Management Studio
The table either does not exist or the current user does not have permissions on that table

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
202
Date Created
Thursday, February 28, 2013
This Article Has been Viewed
2837 times
Short Desc
When connecting to a Linked Server within SQL Server 2005, you may experience the following error, if your SCHEME is not properly defined.
Details
When creating your SQL Script to connect to the Linked Server, you have to make sure that everything is not only spelled correctly, but that you also include the entire SCHEME name if you are using something other than, the dbo to connect with.
Recreate Issue
To recreate this problem:

If you are using a different Scheme than the default [DBO],.

select * from [Hosting].[MyLogin_kb].[myscheme].[Users]
Resolve Issue
To resolve this issue:

When you are connecting to an outside server, you have to add in your logon credentials to your SQL Code if you are using something other than the DBO.
For example:
If your login is: [MyLogin]
And your Scheme is: [MyScheme]
Then you would write it as: [MyLogin_MyScheme]

select * from [Hosting].[MyLogin_kb].[MyLogin_myscheme].[Users]

Break it down:
[Hosting] = This is the Linked Server Name (Usually the name of the Server your connecting too)
[MyLogin.kb] = This is the Database.
[MyLogin_MyScheme] this is the Scheme.
[Users] = This is the Table.

All Topics