I now have 4000+ plus rows after 30 minutes or so !!

select *

from fn_trace_gettable('D:\TraceFiles\MyDMLtrace_SQL_x160627_x1455.trc', 1)

where EventClass in (10,11)

Now I see my "exec USP_MY_StoredProcedure" Call ... Thanks!

Looks like my trace is only capturing event 12 SQL:BatchCompleted

exec sp_trace_setevent @traceidout, 12, 1, @on --SQL:BatchCompleted,TextData

exec sp_trace_setevent @traceidout, 12, 2, @on --SQL:BatchCompleted,BinaryData

exec sp_trace_setevent @traceidout, 12, 3, @on...

No, this gives me 0 results, using the active trace file

select *

from fn_trace_gettable('D:\TraceFiles\MyDMLtrace_SQL_x160621_x146_10.trc', 1)

where textdata like...

FridayNightGiant (6/24/2016)

---

If you want to see the values then you would need to use SQL profiler. Or you can add a a text box to your report and display the...

I believe it's a multi select drop down. They can put a check next to multiple states.

In the stored procedure, I was planning to build a WHERE IN clause for...

Lynn Pettis (5/20/2016)

---

Just curious, if clicking on Modify resulted in an error did anyone try clicking on Script Stored Procedure As, select Alter to, then select New Query Editor Window...

Why did you post in an old, unrelated thread, rather than start a new thread on your topic ??

Import/Export Wizard ?

I use it for basic spreadsheet imports. I have never tried 150 columns, so don't know if there are limits.

I delete in batches of 10000 or so. Perhaps testing different sizes for performance.

You could check the time of day if you only want it to run during off-hours, exit...

Maybe I was hallucinating ?? I changed the "sa" password the next day, and restarted SQL Agent, and it's fine ....

SQL Agent uses Windows Authentication.

Looking at Windows-Services, it shows SQL Server Agent using MyDomain\Administrator

I don't see any "sa" related errors in the various error logs

Nothing useful now after rebooting, but seems it was the "sa" password change, not sure why.

Every company will make their...

Database refresh usually means copying production data to development, stage, test etc, so those environments have "fresh" data.

Migration can mean to copy entire database or groups of databases from 1...

Not quite sure if this addresses your problem, but .....

How about setting the step to automatically retry X number of times if it fails ?

I find that option useful for...