Very Computer

1. Problem: strange error message

I've got strange problem

When i'm running following query

  SELECT
      dbs.dbs_number,
      dbs.dbs_title,
      convert(varchar(10), dbs.creation_date, 103),
      convert(varchar(10), dbs.preview_date, 103),
      convert(varchar(10), dbs.final_review_date, 103),
      isnull(dbs.final_review_user_code,""),
      isnull(dbs.preview_user_code,"")
    FROM
      dbs

it generates an error:

Server: Msg 1038, Level 15, State 3, Line 7
Cannot use empty object or column names. Use a single space if necessary.
Server: Msg 1038, Level 15, State 1, Line 8
Cannot use empty object or column names. Use a single space if necessary.

In most cases it works ok and such expresion(isnull(Field,"")) is even used
in many stored procedures
But sometimes it starts to generate that error message. After waiting some
time and trying to apply change again it applies it successfuly and after it
works ok.
But i just started to generate similar query dynamicaly and pass to server
from COM object and it always generates that error in that case.

What is a problem, is there any real restriction on using empty string?
if yes why it usually allow to use it in stored procedures?
What can i do with it?

I know i can put single space instead of empty string, but in that case i
need to make changes in other places where empty string is expected now.
I could use space from the begining but it worked ok with empty string.

Problem is the same on SQL2000 and SQL7.0

I would be happy to receive any idea/suggestion why it works this way

Thank you

Vitaliy

2. Problem in Query against TEXT datatype

3. Problem Decoding Error Message

4. Timestamp-Column in SQL-Server + ADO + VC

5. Problem with Error Message in VB 3.0 Applications

6. DTS problem...

7. DoEvents

8. Connect from Win32 to Informix-SE on Linux problem (-951 error message)

9. Problem getting error messages on Solaris using Informix7.2

10. Help:Record/Key Deleted message and Error message Numbers