Put an N before the second parameter of sp_executesql.

John

Yes, it'll only return jobs that are scheduled.  Change the INNER JOIN between sysjobs and sysjobschedules to a LEFT JOIN to see all jobs.

John

Have you considered Reporting Services?  One report can use multiple sources, and you can create a subscription to send it out by e-mail.

John

You haven't posted all of your code, because you'd get an error that you haven't declared @SourceDBName with what you have posted.  Once you've fixed that, put a PRINT...

You can use sqlcmd or Powershell, or you can register the instances in their own group and connect to them all at the same time to run the query.  I'm...

Perhaps your statistics are out of date and so you're getting an inappropriate memory grant, causing spillage to tempdb?

John

I think he wants all combinations of one word from each group of synonyms.  The groups are (Employment, Job, Profession, Vocation), (Insurance), (Online, Electronic) and (Application).  I got close, but...

Lorna

This will reduce the number of CASE expressions.  Whether it's actually simpler is for you to decide!

WITH RemoveZeros AS (
    SELECT
        CASE ExchangeRate
            WHEN...

Yes, I would say about the size of the data that's being deleted.  But try it for yourself on a system that doesn't have anything else happening on it, and...

Well, something's changed.  Maybe somebody made an update to the job?  Or perhaps the job code contains some data-dependent conditional logic such that the requirement to use SQL Native Client...

If you want to subtract a value from a previous row, use the LAG function.

John

Mischa

I'm afraid I can't see your screenshots.  Does the script include xp_instance_regwrite, by any chance?  That doesn't show an absolute path, but rather one relative to the hive...

So bal_run is the column you currently have in your result set that has wrong numbers in it?  From your expected results, all you need to do is add Principal...

I think the first sentence means "I had a problem", but the rest is more difficult.  Please could you post in English?

Thanks
John

You've lost me, I'm afraid.  Please will you show us what the results should be?  Sample data in consumable form (INSERT statements) would also be more helpful than a screenshot....