>- see footer for list info -< Wouldn't deleting that schema also remove all info about what objects that user owned ?
Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene Brown Sent: 20 April 2007 14:10 To: Coldfusion Development Subject: RE: [CF-Dev] OT: SQL 2005 >- see footer for list info -< Russ, I had this very issue this morning, in SQL 2k5 users have a schema atatched, quite by accident I found if I deleted the schema (Database, Secuirty, Schema) for the user in the imported database I was then able to delete the user (Database, Security, user), creating the new login and assigning the user access to the newly imported database. Cheers Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 20 April 2007 13:43 To: 'Coldfusion Development' Subject: RE: [CF-Dev] OT: SQL 2005 >- see footer for list info -< I have similar problems when importing an SQL2000 database into SQL2005, the usual methods for syncing the dbuser with the SQL login do not work either, so the database will not work from CF as the login fails. Considering the same stored procs exist in SQL2005 I dunno why they don't work anymore. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allan Cliff Sent: 20 April 2007 09:16 To: Coldfusion Development Subject: [CF-Dev] OT: SQL 2005 >- see footer for list info -< Does anyone know how to change the owner of a table in SQL 2005 (developer edition)? In SQL 2000 it was very simple, i would just create the new login, then assign it as the dbowner of that database, and I would run sp_changeobjectowner against each table. No luck with 2005 though. Thanks Allan --------------------------------- Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for your freeaccount today. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
