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