cowieit

Showing posts with label change database owner. Show all posts
Showing posts with label change database owner. Show all posts

Tuesday, 17 April 2012

MS SQL change DB owner

change database owner

USE vCenterDBname
EXEC sp_changedbowner"username"
eg
USE srmdb
EXEC sp_changedbowner"testdomain\srmadmin"
Posted by Guy at 03:23 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: change database owner
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2014 (7)
    • ▼  September (7)
      • Test Port connectivity with Telnet
      • device manager - hidden devices
      • install uninstall Telnet client on W2008 / Win 7
      • SCCM info
      • set a manual MAC address for a virtual network ada...
      • Mount commands for *nix
      • xcopy / robocopy specific files from a folder
  • ►  2013 (27)
    • ►  August (2)
    • ►  July (5)
    • ►  June (2)
    • ►  May (12)
    • ►  April (3)
    • ►  February (1)
    • ►  January (2)
  • ►  2012 (43)
    • ►  December (4)
    • ►  September (1)
    • ►  May (6)
    • ►  April (32)
Simple theme. Powered by Blogger.