when the job fails.

if you change it to when the job completes, you gent both success and failure emails.

a simple basic example of cross applying a datamath function to get your 36 values based on one date.your example did not go by date, it seemed, though; are you...

Roland are you creating the SPN's manually?

typically, the service account running the SQL service creates the SPN on restart of the SQL service.

That means it needs the Trusted for Delegation...

Incorrect syntax near '@CheckSum' to me implies a missing comma before, or an equals sign after;

as others had posted, if we see the whole command you executed, it might be...

right , the procedures are only part of the settings you need to use.

you need to use both WHERE [arr].Groups LIKE @GroupSearchTerm AND [arr].Users LIKE @UserSearchTerm" in the proc, not...

you wnat your SSRS report to have two text boxes or dropdowns for the  parameters, and to call a procedure.

the procedure then might look something like this, so if they...

not to that level of granularity, but there is a way to code around that.

take a look at this post from a while back where i posted a complete solution...

i hope i am not reading this wrong, but it looks like what you want to do is instead of using SELECT *, to select explicit column names.

good job on...

then in that case, why don't you simply put all of the servers in Central Management Servers, and execute then via SSMS all together?

stick with the tools you know, isntead...

with powershell, here is how i would do it.

Assuming instances_list.txt is a single column list with no header.

also assuming the script has USE [somedb] or fully qualified names so it...

here's a snippet i use:

this will return all failures since the given date(first of the year is my parameter)

you can tweak it from there, i think.

DECLARE @dt...

the SQL Import Wizard will let you select all 260 tables in one go, and save the package for future editing, execution and modification.

one package, 260 data flows.

does the application NEVER write to the database and needs to be fixed, or does the applicaiton writing to the database works for a while, and the stops writing?

there are...

• This reply was modified 6 years, 8 months ago by Lowell.

yes the code has problems, since . the code you pasted is incomplete.

for what you pasted, besides having a lot of whitespace so the...

if you are sure they are using the same sources, then how about a quick and dirty row count and totals by columns?

add some additional group bys to look at...