Beanie posted on September 6, 2009 16:14

A handy built in function of MS SQL that changes the owner of a table or object, simply fill in the table or object name and the name of the new user and execute it.

sp_changeobjectowner  'object' ,  'owner'    

Posted in: Development  Tags:

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Comments

Page List

Search Blog

Tag Cloud

Recent Comments

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2012 Beanie