found it,

look like you have to line them up before deleting http://stackoverflow.com/questions/24829011/powershell-outlook-mark-all-mails-as-read-then-delete

and foreach loop can't be used if you modify collection

what worked for me

$OlderThenDays =...

does not work with $_.Path ( replaced with $_.Fullname) and changed Move-item to Copy-item

but what confuse me that both scripts working and provide same result

Question: I don't provide full path...

Thank you

xft.Script -- does not exist but $xfr.ScriptTransfer() provide readable output

I also found example providing me with result more close to my request

https://www.simple-talk.com/sql/t-sql-programming/dependencies-and-references-in-sql-server/

$scrp.Script($Item) does what it have to do ... generate object script in text format to file or host

what I am looking for is something similar to

$scrp.option | select indexes,...

I tested 2 scenario and can confirm (SQL profiler) that in both scenarios connections is open to SQL server

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null

$inst ='myserver\inst1,7889'

#test1

$cn = "Data Source=$inst;Initial Catalog=master;trusted_connection=true;Application Name=' **TEST** '"

$s =...

I confirm this is power shell problem with monitoring tool.

I got CPU alert from another VM with new SQL instances installed ,

same story ...admin db was missing and...

thanks for the tip about "monitoring tool" ,this is pointed me to right directions

Host using VM-Ware

I called 3-rd party, but it fact it is home grown monitoring based...

could not find how to use " catch [<ExceptionType>]" in my case ,if you have example please post it

found a workaround at https://ask.sqlservercentral.com/questions/119695/powershell-smo-is-not-working-for-non-admin-user.html (see block 35.)

in...

the is some restrictions

no 3-rd party tools

installation done only as silent untended from bat file

From Hadoop theory/testing/improving you skills and working on own projects to landing position/contract in Hadoop

Mistakes/Methodology/Suggestions

Small history

1.Sybase

I was working for 2 years as production SQL DBA at large...

Hi Daniel, thank a lot about DBA carrier path article.

Our company (investment bank ) few months ago came out with plan to use Hadoop.

One part is...