Unfortunately it didn't work for me since I believe master.dbo.xp_delete_file only works with backup and some other files but not with trace files

Found the issue. There was another folder created under msdb and all the packages were moved there. After I moved couple of packages back to msdb, reran the job and...

Thanks Phil. The link you shared was very detailed and helpful but unfortunately we don't want to build SSIS catalog. I still don't understand why the job runs when I...

"C:\program files (x86)\Microsoft SQL Server\150\DTS\Binn\dtexec.exe" /SQL "PackageName"  /SERVER sqlserver /CHECKPOINTING OFF /REPORTING E

I changed the job to point to old server and I no longer run into an issue. All...

• This reply was modified 2 years, 2 months ago by  Chitown.

Target server version is set to SQL Server 2019.

We use a third party tool 'ControlM' to create jobs, execute them since we have hundreds of jobs which run everyday so...

After changing just the compatibility level, queries are running efficiently. Thanks all...

Did you expand the AG then databases and see what it shows on other replicas which are part of forwarder? If it is in red then I believe it is...

Use DB.....That's where the problem was...... 🙂

Enterprise edition. DB is in simple recovery even though it is prod and we are aware of the data loss if there are any issues. 200GB of memory with 56...

No wonder I am losing hair.....

So I created one of the table from an existing DB, created one non clustered index, inserted more records into it. Made it 85% fragmented....

• This reply was modified 3 years, 3 months ago by  Chitown.

What if I save the DDL as .sql file and use powershell to execute that command from the location on each database? Will that work? If so, then what's the...

Truncating tables is out of the question as of now I think.

So what I did was (just for 1 DB), I generated the script from the Source and executed...

My apologies, the source server is running on 2008R2 and the destination server is on 2014

Guys I do appreciate you telling me that this is not a good practice and I do agree but this is what I was asked to do. And before we...

Chitown (9/8/2016)

---

Expert, I am working on scheduling a job which runs every 10 minutes and kill any active session (which is active for more than 10 minutes) from a specific...