RE: Rename table from stored procedure

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

From: Hermilson T (hertino_sql_at_hotmail.com.INVALID)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 05:51:03 -0700

Hi, with this ..

Syntax Books On Line:

sp_rename [ @objname = ] 'object_name' ,
    [ @newname = ] 'new_name'
    [ , [ @objtype = ] 'object_type' ]

Recalls the permissions [sysAdmins, dbOwner] and that can change objects in the current database only.

Hermilson
Colombia

Relevant Pages

  • Re: INSERT an UPDATE permission denied on object
    ... Even if you are in the role of dbowner you could been blocked for some ... reason with a deny rule. ... > I have a problem when i try to insert or update in a particular database ... > but if i use a SQL Login is ok. ...
    (microsoft.public.sqlserver.security)
  • Basic Server Roles (security) question
    ... database on my SQL 2000 SP3 server (so DBOWNER is ok with me). ... But I also need them to be able to schedule a job against that database ...
    (microsoft.public.sqlserver.security)
  • Re: database chain issue; DBO loginname change?
    ... i was using sp_dbchangedbowner on the wrong database. ... Database B was consistant in this manner. ... i believe that the dbowner and the dbo-loginname should equate. ... >> I see one inconsistancy, ...
    (microsoft.public.sqlserver.security)
  • Null Values
    ... Hermilson T. ... there are columns in my database which shows ... >it produces 0 results and replacing the where criteria ... in sql query? ...
    (microsoft.public.sqlserver.programming)