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...

on each server, can you check this Server Setting?

Perform Volume Main task for fast database creation.

if you changed the service account after the initial install, i might expect to see...

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, 1 month 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...

i might consider checking the  ansi and date_format sessions settings for default dates, as they could be different on the server, running as an agent , vs running in SSMS

ie...

without using .NET, then no, the specific file extension *.msg ends up requiring C# to do something like this, since the msg is a binary file:

you could save as text...