Viewing 15 posts - 271 through 285 (of 5,109 total)
That is just one issue, and the error message seems clear. This is running on the server and therefore (presumably) it cannot access that path when it runs.
Ideally, you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 2, 2021 at 4:10 pm
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 2, 2021 at 1:27 pm
You are correct, the problem is the hyphen. You will need to delimit identify the object name: [DT-SERVICES-TEST].
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 30, 2021 at 2:01 pm
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 30, 2021 at 11:53 am
Have a read of Jeff Moden's articles Cross Tabs and Pivots. They explain exactly how to achieve what you're after.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 30, 2021 at 11:30 am
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2021 at 2:52 pm
As you suggest, the /passive flag on the command line bypasses the restriction.
Why have I only just discovered this... Literal head desk moment...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2021 at 11:30 am
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2021 at 11:24 am
But, again, coming back to my original question --> How do I make sure that ALL the SPs are at least attempted to run sequentially ? Thanks in advance.
What...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2021 at 10:44 am
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 21, 2021 at 3:18 pm
Dynamic SQL is the only way to go, as Phil says. So one way would be like so:
DECLARE @SQL nvarchar(MAX),
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 17, 2021 at 3:09 pm
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 14, 2021 at 2:04 pm
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 14, 2021 at 2:00 pm
So do I still need the Script Task with the C# Code?
Depends if you need to do what you need to do in the script task. You're using it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 8, 2021 at 4:04 pm
If you want to "skip" a step, you'll need to have 2 paths to the step *after* the one you want to skip. The flow that goes to the skippable...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 8, 2021 at 3:47 pm
Viewing 15 posts - 271 through 285 (of 5,109 total)