I'd need to know what kind of credentials they are using, and how those are managed, before I could even begin to answer this. Are they using SQL logins,...

If you don't want the other two performances in the query, why does it have, "OR p.perf_no in (6352,6353) " in the Where clause?

Because for a lot of people, that's the trickiest SQL question...

Will a trace do what you need? You can capture all commands issued to the server, filtered by account/connection.

Can you provide rough-draft code for the outer and inner procs? It's quite likely that it can be rewritten into a single procedure that will do everything you need,...

On further thought, if they aren't supposed to access the database at all, why do their accounts allow it? You can set up SQL Server to deny the right...

You can run a DML trace that will capture all queries run against the database. Take a look at "sp_trace_create" in Books Online (or on MSDN) for details on...

Are there numbers in that column when it's non-Null? If so, do they include numbers below 1 (zero or negative or fractions)?

If it's numeric, and if 1 is lowest...

Yes, you'd need to log that data to report against it.

In your query of the log data, can you use the "For XML Path" trick to concatenate it all into a string?

What edition of SQL Server are you using? Express, Workgroup, Standard, Enterprise/Dev?

OTF (10/14/2010)

---

alen teplitsky (10/13/2010)

---

i'm in the process of collecting performance data and creating reports about it. next up is i want to collect data every hour or so on how...

You might be having a problem with the "where not in" part that queries the target table.

Have you tried logging the inserted rows in a temp table, using the Output...

There's a bit of information on that available. Have you tried using Bing/Google/whatever to search for "ssis 32 bit" and "ssis 64 bit"?

Are you even sure it's the For XML part that's causing the problem? Have you run side-by-side tests with and without that clause on the same data+query+parameters?