SQL Query Fails through Powershell

i trying alter permission set on assemblies using powershell , keep getting same error. life of me, cant figure out may going wrong here. appreciated.



# 1.2. 4 load required assembly  [system.reflection.assembly]::load("microsoft.sqlserver.smo, culture=neutral,version=11.0.0.0, publickeytoken=89845dcd8080cc91")  # 1.2.5 connect sql instance (in case default instance)  $sqlserver = new-object ("microsoft.sqlserver.management.smo.server") "."  # 1.2.6 show current sql version. not required verifies if connection can established  $sqlserver | select edition, versionstring  #wi: change security settings:  $sqlserver.databases |          foreach-object {              $db = $_             $db.executewithresults('select * sys.assemblies') } |              foreach-object { $_.tables[0] } |                 %{                      write-host "alter assembly [$( $_.name )]  permission_set = safe"                      $db.executewithresults("alter assembly [$($_.name )]  permission_set = safe")                  }         

the error message is



exception calling "executewithresults" "1" argument(s): "execute results failed database 'test'. " @ line:22 char:63 +                     $db.executewithresults("alter assembly [$($_.name )]  p ... +                                                               ~~~~~~~     + categoryinfo          : notspecified: (:) [], methodinvocationexception     + fullyqualifiederrorid : failedoperationexception



---

lokesh gunjugnur

hi anna,

the problem more fact trying change system assemblies why getting error. adding appropriate filter, able resolve problem.

thanks help.

regards,

lokesh

---

lokesh gunjugnur

Windows Server  >  Windows PowerShell