rename a table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: TJS (nospam_at_here.com)
Date: 06/08/04 

Date: Mon, 7 Jun 2004 20:54:04 -0700

I am trying to rename a table from a query by this statement

Execute sp_rename 'SubMenuItem', 'Portal_MenuSubItems'

but it gives me an error message :

The following error occured while executing the query:
Server: Msg 15225, Level 11, State 1, Line 273
No item by the name of 'SubMenuItem' could be found in the current database
'Portal', given that @itemtype was input as '(null)'.

The name is correct...

what @itemtype is it looking for ????????

Relevant Pages

  • Re: IIf dilemma
    ... John, Here is the SQL..... ... The error message I received is......"You tried to execute a query that did ...
    (microsoft.public.access.queries)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... The error message was "could not execute query". ... format' 'artist'. ...
    (comp.lang.php)
  • Re: lack of errormessage
    ... That error message is by design. ... You can't execute a SELECT query. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... >> What error message did you get when you executed the query? ... or die ("could not execute query because ... > checked i got the same error message by typing in a load of random ... Tom Thackrey www.creative-light.com tom creative light com do NOT send email to jamesbutler@willglen.net ...
    (comp.lang.php)
  • Re: rename a table
    ... Who is the owner of SubMenuItem? ... >I am trying to rename a table from a query by this statement ... > Execute sp_rename 'SubMenuItem', 'Portal_MenuSubItems' ... > but it gives me an error message: ...
    (microsoft.public.sqlserver.programming)