If I stop shrink command before its completion, does it rollback everything ?

Instead of running it via a SQL job, it makes more sense to run it using SQL Alert as using SQL job you can only schdule to run it every...

Many thanks Perry. It is working.

Using this encrypted pswd, failing to connect to Oracle Instance..

$password = read-host -prompt "Enter your Password"

$secure = ConvertTo-SecureString $password -force -asPlainText

$secure

$bytes = ConvertFrom-SecureString $secure

$bytes

$username = "usr"

$tnsalias =...

Even could not able to pass it properly to the connection string using $bytes and username too.

$password = read-host -prompt "Enter your Password"

$secure = ConvertTo-SecureString $password -force -asPlainText

$secure

$bytes =...

Awesome....Thnx..Just wanted to be double sure

In my case it is just SQL Account but not the "domain account"..

Thanks Steve. But here in this case it is required to check ":SQL Login accounts", not windows. Can this also work through group policy settings change?

I used this below query. Is this worthful though not getting any data.

SELECT

*

FROM sys.dm_exec_requests er INNER JOIN

sys.dm_exec_sessions sp ON er.session_id = sp.session_id

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt

CROSS APPLY sys.dm_exec_query_stats AS qs

--CROSS...

Does it give the Lead blocker and the blocked sessions??

Did it fix the dtc problem by increasing the time out value? Please suggest!

What about the below..?

ErroRCode : 0x139F

CallingAPIName : NLShimImpersonate

API Name: ImpersonateSecurityContext

Thanks Gila.

Wanted to add that, DTA sometimes recommends to create custom stats based on the workload data. Even in many cases, DBA/Dev create custom stats for the query optimizer to...

Thanks Jeremy. The query looks good. But I cant find any session by providing the "job name"

Does not say anything bossy!! Checked via Job activity monitor tool too. No luck.