| Vinayak Tadas[MSFT] 2005-04-07, 6:03 pm |
| How are you transferring data between the staging server and the live
server. Are you using sql replication ?
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/_cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/secur_ity.
Please
reply to the newsgroups only. Thanks
--------------------
From: "Lance" <lance@[nospam]keayweb.com>
Newsgroups: microsoft.public.commerceserver.catalog
Subject: Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid
object name 'dbo.ThomasCamp_ClassTypes'.
Date: Mon, 14 Mar 2005 14:59:10 -0000
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <113b9m5f656un44@corp.supernews.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.181
X-Complaints-To: abuse@supernews.com
Lines: 25
Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!
diablo.voicenet.com!tdsnet-transit!newspeer.tds.net!sn-xit-03!sn-xit-09!sn-x
it-08!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.commerceserver.catalog:5308
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Hi,
I am having a problem exporting a product catalog. The SQL server has two
stores set up on it: one for live transactions and one for staging. The
staging DB is just a restore from the live DB. When I attempt to export a
catalog from the staging DB using the Catalog Manager, I get the following
error:
Source:Microsoft OLE DB Provider for SQL ServerDescription:Invalid object
name 'dbo.ThomasCamp_ClassTypes'.
This error is not replicated in the Event Log. It is only seen in the
Catalog Manager.
Now, I know that this object is a view in both DBs, and I can manually query
from it and it seems to return valid sets, so why does SQL server think that
it doesn't exist?
Thanks,
Lance
|