Re: Thanks, but..

Zorpiedoman (nowheremane@xxxxxxxxxxx) writes:
> Thanks Erland, however the error message leads me to believe that may
> not be the cause. The error is saying:
>
> Invalid Object Name 'BS2.BS2.dbo.Accounts'

Moral: always include the error message you are getting.

I used the SQL Profiler to see what Enterprise Manager is up to. It turns
out that it generates this command:

exec sp_executesql N'UPDATE "JUNI.bos_sommar"."dbo"."currencies" SET
"curpriceib"=@P1 WHERE "curcode"=@P2 AND "curname"=@P3 AND ...

Note how the first pair of " are placed. That does not mean the linked
server JUNI and the database bos_sommar. That means the database
"JUNI.bos_sommar".

Thus, a pure and plain bug.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

Relevant Pages

  • Re: How is VFP comparing to C#/VB in terms of performance to SQL Serve
    ... You can't write it to your database because it's down. ... Isn't that when you throw up a box with some kind of cryptic error message and offer to report it to Microsoft before you app crashes taking the data with it? ... It is possible to write slow applications in VFP and it is equally possible to write slow applications in VB/C#. ... If the SQL server is down, where do you log the error message? ...
    (microsoft.public.fox.helpwanted)
  • "The parameter is incorrect" error, adding table in Database Explorer
    ... Whenever I attempt to "Add New Table" to a SQL Server 2005 Express database ... get a pop up error message stating "The parameter is incorrect". ...
    (microsoft.public.vsnet.general)
  • Re: DNS Server Error when Hitting Database?
    ... What is the specific error message you are seeing? ... The application accesses a SQL Server database ... The SQL Server account in question is an owner for the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help Please!
    ... permission issue with connecting with your database. ... posted the entire error message to be sure. ... And can you tell me please where the SQL Server is ... located relative to the machine on which the Database Results page is? ...
    (microsoft.public.frontpage.programming)
  • Problem connection to SQL Server DB using ODBC
    ... Could not allocate disk space for a work table in ... the database by using ALTER DATABASE. ... SQL Server 2000 (inc ... same error message. ...
    (microsoft.public.sqlserver.server)