Nice example

based on some ideas gained from
https://www.sqlservercentral.com/Forums/1324026/Searching-for-strings-in-SSIS-packages

the following query shows the inital part of what is stored in the packagedata column  of msdb.sysssispackages table

SELECT ...

> Correct answer: This function returns a GZip compressed version of the string.

I disagree with the answer.

COMPRESS can return a GZip compressed version of the string, but it does...

Yes, sp_update_job solved the problem because it flushes the SQL Server Agent cache.

exec @Severity=[msdb].[dbo].[sp_update_job] @job_name='JDN_BRD_Play 2', @enabled=@EnableIRMSjobs

It also solved the problem that was the initial symptom of the problem in...

Found possible answer in:

http://www.sqlservercentral.com/Forums/Topic650924-146-2.aspx

Lynn Pettis (4/20/2010)

---

The reason I was asking is i had a similar problem when I would failover our mirror databases. The code that was...

I have a client who is running SQL Server 2005 and we are trying to disable/enable SQL jobs using a SQL stored procedure.

I have two play jobs that just send...

Great question. Made me dig into BOL and learn.

I did get to finish lunch 🙂 even though I currently have no responsibility for backups/restores.

Thanks.

Concatenating Unique Field Values

Lynn's solution does a great job of concatenating field values into one string. However, it repeats duplicates, which can be quite annoying with many duplicates.

If we...

Thanks for article. Good reminder.

Thanks for the Interview test.

In a former consulting job (not SQL developer), I interviewed a candidate who did a great job of reading the answers from the questions and got...