Group:  Microsoft Access ยป microsoft.public.access.adp.sqlserver
Thread: sp_addextendedproperty error

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Re: sp_addextendedproperty error
"Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> 06.02.2006 21:38:04
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

Re: sp_addextendedproperty error
"Vadim Rapp" <vrapp[ at ]nospam.polyscience.com> 07.02.2006 15:18:04
This is a multi-part message in MIME format.

------=_NextPart_000_00A4_01C62BC7.667333B0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_00A4_01C62BC7.667333B0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY><!-- Template: 'Reply News (00000007)' --><!-- Greeting -->
<DIV><FONT size=3D2>Hello tolgay:<BR>You wrote  on Thu, 9 Feb 2006 =
09:59:28=20
+0200:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV><!-- Body text -->
<DIV style=3D"COLOR: #000000; BACKGROUND-COLOR: #ffffff"><FONT =
size=3D2> t>=20
It is an easy query ( select * from table1 ) and it doesn't matter=20
the</FONT></DIV>
<DIV style=3D"COLOR: #000000; BACKGROUND-COLOR: #ffffff"><FONT =
size=3D2> t>=20
query code because I get the error whatever in the code.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Apply the<A=20
href=3D"http://www.microsoft.com/downloads/details.aspx?FamilyID=3D8e2dfc=
8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=3Den">=20
latest sql server service pack </A>on your machine and on sql server =
machine (if=20
not the same). If that does not help, reinstall your client tools and if =
that=20
does not help, reinstall sql server.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Vadim Rapp</FONT></DIV></BODY></HTML>

------=_NextPart_000_00A4_01C62BC7.667333B0--

sp_addextendedproperty error
"tolgay" <tgul[ at ]tgul.com> 08.02.2006 10:43:08
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


Re: sp_addextendedproperty error
"tolgay" <tgul[ at ]tgul.com> 09.02.2006 07:59:28
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.


"tolgay" <tgul[ at ]tgul.com> wrote in message
news:e4Z%23JnwKGHA.2828[ at ]TK2MSFTNGP12.phx.gbl...
[Quoted Text]
> 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
>
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net