What sort of help do you want?

Hi all,

I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.

I need to create one more SQL...

Phil,

The caller is the same for another packages that are running ok, in the connection string it has a username and password with sysadmin privileges to connect to the...

If you look at the Overview page of the All Executions report, you will see at the top right a property called 'Caller'.

Can you confirm that the user mentioned here...

Phil, the SET RESULTS SETS is outside of the procedure and used to re-define the output of the stored procedure. I just learned that today as I have never...

The important clause is WITH RESULT SETS, not SET RESULT SETS, and if your data source stored proc is returning data from a temp table, its presence is mandatory, to...

Regarding this

A OLEDB source with an stored procedure with RESULT SETS specified

I just want to check. Is 'WITH RESULT SETS' within the stored proc itself, or do you have

EXEC PROC...

You can filter out services which are not set to start automatically by referencing the ServiceStartMode enum. That might be the closest you can get to 'in stopped state...

What does your script do?

Use XP_DIRTREE instead?

Check here for some ideas.

It sounds like you need to introduce a queueing system. The execution of the proc needs to be decoupled from when the web service triggers.

Your web service adds entries to...

OK, so can you change the process which triggers the execution of the proc so that it executes only one instance at a time?

Can you clarify the problem a little, please? Is it

a) Files are not processed in the correct order, or

b) Multiple files are processed at the same time (because multiple instances...

All of our solutions come crashing down if the start and end times span midnight, of course.

To import xlsx files (in both 2015 and 2017), you need to install the ACE drivers. Ideally, you should install both the 32- and 64-bit versions. This link will...

My version looks similar to the above!

DROP TABLE IF EXISTS #Time;

CREATE TABLE #Time (StartTime INT, EndTime INT);

INSERT #Time (StartTime, EndTime)
VALUES
(830, 1100)
,(1200, 1600)
,(0, 2359);

SELECT
    calcs.StartTime
,...