What about if that file is not removed from the folder at the end of the day and another is not put in its place... will it not reprocess...

Ideally, you...

None of them, the above link is for installing SQL Server 2014 Express at SP3, not updating an existing instance to SP3. You want Microsoft® SQL Server® 2014 Service...

You are correct, the problem is the hyphen. You will need to delimit identify the object name: [DT-SERVICES-TEST].

SQL Server doesn't store information of who last altered an object. It does store the last modified date for objects like procedures though.

If you need to store such information you...

Have a read of Jeff Moden's articles Cross Tabs and Pivots. They explain exactly how to achieve what you're after.

ISNULL returns the data type of the first parameter.The first parameter of  your ISNULL function is NULLIF('','') which if we use dm_exec_describe_first_result_set we can see returns a varchar(1). As a...

Why have I only just discovered this... Literal head desk moment...

Hi Thom A, sorry if did not make my reply clear. My question is : While running AllMySPs, if SP1 encounters some error and fails, then the following statements...

What...

Have you got both the 32- and 64- bit versions of the drivers installed?

(SSDT uses the 32-bit version and (by default) DTExec will use the 64-bit version – might...

Dynamic SQL is the only way to go, as Phil says. So one way would be like so:

DECLARE @SQL nvarchar(MAX),
       ...

Seems like, ideally, you'd be best added a "ModifiedDate" column to your data, which has both a default value populated with the current date and time, and then when you...

Brief tangent into real SQL stuff...

Has anyone ever heard of table triggers not firing for every row if you do set-based updates to records?

Our vendor sent us code for...

Depends if you need to do what you need to do in the script task. You're using it...