skip to main | skip to sidebar

Technology at work

Monday, August 27, 2007

updating db user on migrated VC DB

select 'exec sp_changeobjectowner ''' + 'DOMAIN\USER' + ''', ''dbo'''
from sysobjects
where uid = user_id('old_USER')
Posted by Boris Mikhailovski at 10:51 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (1)
    • ►  May (1)
  • ►  2010 (5)
    • ►  June (1)
    • ►  May (4)
  • ►  2009 (11)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  April (1)
    • ►  February (5)
    • ►  January (2)
  • ►  2008 (5)
    • ►  December (1)
    • ►  February (2)
    • ►  January (2)
  • ▼  2007 (9)
    • ►  December (1)
    • ►  October (2)
    • ▼  August (6)
      • updating db user on migrated VC DB
      • unlink NIC from ESX vSwitch
      • SUSE 10 SP1 on ESX
      • [VpxdCert] Failed to decrypt password: applying pr...
      • vswif0: transmit timed out.
      • locate VM and related PID on ESX

About Me

Boris Mikhailovski
View my complete profile