June 30, 2008 at 8:29 am
Looks to me weird problem. I am running distributed quries on the server and it's working fine with all the tables except one. I am getting following error while executing distributed queried on one table.
Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "GMSC12MS".
This owner of this table is dbo.
Any help will be appreciated.
June 30, 2008 at 2:51 pm
balbirsinghsodhi (6/30/2008)
Looks to me weird problem. I am running distributed quries on the server and it's working fine with all the tables except one. I am getting following error while executing distributed queried on one table.Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "GMSC12MS".
This owner of this table is dbo.
Any help will be appreciated.
To beat a thoroughly dead horse that's been hashed multiple times in this forum: Is there a question here? Do you want help with understanding the error message? Do you want help rebuilding your database to be internally consistent? You have an error message talking about schema, catalog, provider and linked server. Then you say the owner of this table is dbo. That's very nice.
July 1, 2008 at 1:27 am
July 1, 2008 at 10:28 am
I have figured out the issue.
The query I was using was like that.
Select * from serverName.DatabaseName.dbo.[tablename]
but the table name had space at the end like this [tableName ] so I was using table name without a space.
Following is the right query for the table name which has space in it. when I use this I don't get error.
Select * from serverName.DatabaseName.dbo.[tablename ]
September 13, 2008 at 1:22 am
Hi
Please check your SQLSERVER service account.
Start service with domain account
January 29, 2009 at 7:00 am
Thank you so much! I've had exactly the same problem and it's been driving me mad for 2 days now.
A quick note to Mr or Mrs. 500 - if you don't have anything useful to post then please don't bother.;)
January 29, 2009 at 9:28 am
Debbie, You are right. There are some people in this form are rude and frustrated from there life. I really ignore them and don't pay attention at all.
I think this is a great site to share your views.
December 18, 2010 at 10:42 pm
thnaks a lot for the advice. i ahd the smae issue and wasted almost an hour to solve this problem !!!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply