Friday, February 24, 2012

Error 2809

What is error 2809?
We are running SQL Server 2000 Enterprise on a W2K cluster.
I have been seeing Error 1203 in a profile trace. I successfully applied
service pack 3a and Error 1203 has stopped, but I still see error 2809
periodically.
Also, when I run "select @.@.version", the response says '...build 2195:
Service Pack 2' and doesn't mention service pack 3a. Is this normal?
Thanks
Bill
Hi
Build 2195 is Windows 2000. The SP2 reference is Windows 2000 SP2. That is
the Os information.
When running select @.@.version, the values after 8.00.xxxx are what determine
the SQL Server version
SP3a = 8.00.760
If I were you, get onto Windows 2000 SP4 asap.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd#yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>
|||I see. Thanks.
Do you know what the Error 2809 is? I can't find much about it.
"bill" <belgie@.datamti.com> wrote in message
news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> What is error 2809?
> We are running SQL Server 2000 Enterprise on a W2K cluster.
> I have been seeing Error 1203 in a profile trace. I successfully applied
> service pack 3a and Error 1203 has stopped, but I still see error 2809
> periodically.
> Also, when I run "select @.@.version", the response says '...build 2195:
> Service Pack 2' and doesn't mention service pack 3a. Is this normal?
> Thanks
> Bill
>
>
|||Hi
Not see that one around. Do you always get it on a specific query?
2809, Sev 16.
The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.
Not much out there about it. If you can figure out in what scenarios you get
it, PSS might be able to help
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bill" <belgie@.datamti.com> wrote in message
news:eHAkDB$yEHA.3844@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> I see. Thanks.
> Do you know what the Error 2809 is? I can't find much about it.
>
> "bill" <belgie@.datamti.com> wrote in message
> news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
applied
>
|||It is what pretty much what you see in the full description:
A request for an object of the wrong type - such as trying
to execute a view or a table instead of a stored procedures.
I've generally seen it with ADO apps that have some problems
with OpenReecordset commands - usually when table names are
used for the data source instead of a select statement.
-Sue
On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
<belgie@.datamti.com> wrote:

>I see. Thanks.
>Do you know what the Error 2809 is? I can't find much about it.
>
>"bill" <belgie@.datamti.com> wrote in message
>news:OnTnOd%23yEHA.3548@.TK2MSFTNGP09.phx.gbl...
>
|||OK, I think you're right - the database is sometimes used by some MSAccess
ADPs and when the code uses a DLOOKUP function on a table, it looks like it
tries to execute the table as if it was a stored procedure, and I see the
error.
Thanks for your help.
-Bill
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:nh7kp05nnnh65v81qbit3iae04sa9dtd38@.4ax.com... [vbcol=seagreen]
> It is what pretty much what you see in the full description:
> A request for an object of the wrong type - such as trying
> to execute a view or a table instead of a stored procedures.
> I've generally seen it with ADO apps that have some problems
> with OpenReecordset commands - usually when table names are
> used for the data source instead of a select statement.
> -Sue
> On Tue, 16 Nov 2004 10:23:41 -0500, "bill"
> <belgie@.datamti.com> wrote:
applied
>

No comments:

Post a Comment