sp_addextendedproperty error

[Vadim Rapp]

Hello tolgay:
You wrote on Wed, 8 Feb 2006 12:43:08 +0200:

t> I try to create a query view in Entrerprise Manager and I get an error
t> about sp_addextendedproperty. What could be reason for the error ?

Obviously, (or, as offshored Microsoft tech support would put it, "it looks
like") you specified invalid parameter for procedure sp_addextendedproperty
.. How did you call it?

Vadim Rapp

 

[Vadim Rapp]

Hello tolgay:
You wrote on Thu, 9 Feb 2006 09:59:28 +0200:

t> It is an easy query ( select * from table1 ) and it doesn't matter the
t> query code because I get the error whatever in the code.

Apply the latest sql server service pack on your machine and on sql server machine (if not the same). If that does not help, reinstall your client tools and if that does not help, reinstall sql server.

Vadim Rapp

 

[tolgay]

I try to create a query view in Entrerprise Manager and I get an error about
sp_addextendedproperty. What could be reason for the error ?

The full error

ODBC eror. Microsoft ODBC sql server driver sql server
An invalid parameter or option was specified for procedure
'sp_addextendedproperty'

Thanks

 

[tolgay]

It is an easy query ( select * from table1 ) and it doesn't matter the query
code because I get the error whatever in the code.