>- 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 -<
