i actually wrote this article. Is there any issue  with this?

Thanks

How large is database and how frequent data is updated/deleted in tables ?

for larger index indexing takes time and this is useful feature in that case

recreate the index with resumable option ON .

Thanks folks ..

and how to do that ?

dont have any idea about WMI alerts .

any link any guidelines

already on that level

i found out that

actually VM is configure as 1 core per CPU hence 16 core 16 cpu

And std edition suooprts 4 cpu only .. hence we need to...

the above querry shows only available Cpu online as 4 only ..

Hi Gail

in the error message it shows..

16 processors with 16 core is detected ..sql is 4 cpu only...

Yes they are using some machenism in Package itsel to encrypt and decrypt././

Executed as user: ********\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:27:30...

i m running job using sql server agent service acccount . n given the permision also to this nt account ..

also i tried proxy account

Ohh Yes .. even on MS virtual LAB they Show DAtabase Adventure works 2016 but the compatibility level is of 120

but we can use profiler remotely or as u said by using TSQL right ? extended events are good but for earlier version profiler was better idea

USE PROFILER .. TO FIND OUT WHAT HAPPEN S AT FIRST TIME THEN ANALYIZE THAT

U can migrated the report database and and encryption key and then check if everything is working or not

http://www.sqlservercentral.com/blogs/sqlserversdba/2015/06/11/sql-server-reporting-service-migration/ check this out will be helpful