Michael Maddison
michael at ddisolutions.com.au
Thu Jul 6 21:48:42 CDT 2006
Its system sp. (sp_) Make sure your login has ddladmin permissions... >From BOL Members of the sysadmin fixed server role, the db_owner and db_ddladmin fixed database roles, or the owner of the object can execute sp_rename. Only members of the sysadmin and dbcreator fixed server roles can execute sp_rename with 'database' as the object_type. Does the sp run from QA? cheers Michael M On 6 Jul 2006 at 15:52, Kaup, Chester wrote: > Answers to your questions below. How about posting the sp? -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com