Wednesday, February 15, 2012

Error 195 from withing Ent Mgr

From SQL 2000 Ent Ed. sp3
When I try to view permissions via the enterrpise mgr for any object from
any database on this server I receive the following error:
<title>= Microsoft SQL-DMO (ODBC SQLState: 42000)
<msg>= Error 195: 'schema_name' is not a recognized function name.
Research I googled relates to mal-formed queries or 3rd party software as
the cause. Any ideas...?
Thanks in advance,
ScottOne more thing...
I just found out that MS Operations Management Agent was installed (w/out my
knowledge). Could this be the cause?
"Scott O'Donnell" wrote:
> From SQL 2000 Ent Ed. sp3
> When I try to view permissions via the enterrpise mgr for any object from
> any database on this server I receive the following error:
> <title>= Microsoft SQL-DMO (ODBC SQLState: 42000)
> <msg>= Error 195: 'schema_name' is not a recognized function name.
> Research I googled relates to mal-formed queries or 3rd party software as
> the cause. Any ideas...?
> Thanks in advance,
> Scott|||i have this problem:
when i execute this
SqlCommand mCmd = new SqlCommand( sQry,mConn );
mCmd.CommandType = System.Data.CommandType.Text;
mCmd.ExecuteNonQuery();
where sQry = "UPDATE StoreOperation SET Data=DateAdd(HH,FreqOra,DataAdd(
d,FreqData,Data )) WHERE IDStoreOperation=1"
i have this error message
"DateAdd is not a recognized function name"
in C++ the same sQry work fine. in .NET no.

No comments:

Post a Comment