Using a variable for $db.SetOwner

-

does know how can use variable this?

$owner = "someowner" $srv = new-object microsoft.sqlserver.management.smo.server($destinationinstance) $db = new-object microsoft.sqlserver.management.smo.database $db = $srv.databases.item($sourcedbname) $db.setowner($owner, $true)

gives me errors when try above.

if use $db.setowner('sa', $true) works need hold variable.



system.argumentexception: login 'microsoft.powershell.commands.internal.format.formatstartdata microsoft.powershell.commands.internal.format.groupstartdata microsoft.powershell.commands.internal.format.formatentrydata microsoft.powershell.commands.internal.format.groupenddata microsoft.powershell.commands.internal.format.formatenddata'

this error message indicates $owner variable contains format object not simple string. format objects procuced after pipelining data through format-table cmdlet. assigning such objects string variable produces default behaviour, ie, type of object components displayed. avoid using format-table , use out-string instead , example.

for further details : http://social.technet.microsoft.com/forums/en-us/winserverpowershell/thread/fb956c33-075e-4b17-9a30-5e7ed38ef2aa

wizend




Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

directory stack

-
witchcraft>> $algo -eq $null true witchcraft>> cd $algo.key # directory stack: --- ---------------- 0 c:\users\voodoomsr\valhala 1 c:\users\voodoomsr\valhala\witchcraft\expectopatronum 2 c:\users\voodoomsr\valhala\witchcraft\expectopatronum\comunidad 3 c:\users\voodoomsr\valhala\witchcraft\expectopatronum\comunidad\stack 4 c:\users\voodoomsr\valhala -> 5 c:\users\voodoomsr\valhala\witchcraft witchcraft>> hi all, found extrange thing don't understand. if execute set-location inexistence object list of directories. what that? i see it, can't reproduce it.   when enter you've got posted there, set-location error, because value of argument "path" null.     [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " " mistake!. after that, check alias cd , asigned function set-locationex. fu...
Read more

After enabling Windows Server 2012 R2 DHCP Failover Getting Packet dropped because of Client ID hash mismatch

-
we have 2 dhcp servers @ our site (they each located on different subnets).  these dhcp servers running windows server 2012 r2.  dedicated dhcp servers.  yesterday afternoon, reconfigured several scopes such become members of single dhcp failover relationship have configured load balance 50% of load placed on each dhcp failover relationship member (dhcp server). however, morning, users reported unable renew dhcp addresses.  looking dhcp logs on both dhcp servers, there several entries follow: "36,mm/dd/yyyy,hh:mm:ss,packet dropped because of client id hash mismatch or standby server.,ip subnet,,mac address,,0,6,,,,,,,,,0" i performed manual synchronization of failover relationship , scopes on both dhcp servers.  restarted dhcp service on both dhcp servers still getting same error. a bing/google search did not bring light issue encountering.  has encountered , if so, solution. i should add when attempted perform ipconfig/renew on workst...
Read more

WMI Repository 4GB limit - Win 2003 Ent Question

-
Image
hi there, i've question size limit on wmi repository (being 4gb). if isn't correct place post this, apologies , can let me know wheere post this? i've come across few servers running citrix have reached limit on wmi repository size , need install ibm director agent hw monitoring. during install getting 'out of disk space' errors entered in mofcomp.log: "(mon apr 02 04:10:36 2012.172843) : error occurred while processing item 4: (mon apr 02 04:10:36 2012.172843) : error number: 0x8004103b, facility: wmi description: out of disk space" when error number http://msdn.microsoft.com/en-us/library/windows/desktop/aa394559%28v=vs.85%29.aspx i see this: wbem_e_out_of_disk_space 2147749947 (0x8004103b) disk out of space or 4 gb limit on wmi repository (cim repository) size reached. windows xp , windows 2000/nt:   disk out of space. i'm wondering if there reason why limit set 4gb or can increase needs be? can't seem find reas...
Read more