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

Reply via email to