If you open the job and select Steps on the left, what is the Type of the job step? It should be "Operating System (CmdExec).

😎

Mike Scalise (9/27/2016)

---

Hi,

Has anyone run the latest Ola Hallengren's IndexOptimize script (September 25)?

I'm not sure why but when I run the job, I get the error "Executed as user: NT...

I thought there was something odd with desired results 😉

😎

Here is a solution to your problem...

Jeff Moden (9/26/2016)

---

We've just been through patch hell. It broke some very important C# code on one of our servers. We had to roll back the update in...

I'm just to lazy to write "(SELECT NULL)" when @@VERSION does the same thing, that is tells the server to...

Quick questions, are you using SQLite or SQL Server? Can you post the DDL (create table ) scripts for the relevant tables, sample data as an insert statement and the...

Can you please post the DDL (create table) scripts for the relevant tables and sample data as an insert statement?

😎

The design and the desired results are somewhat odd as it requires a union of the reference data.

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

IF OBJECT_ID(N'tempdb..#SourceData') IS NOT NULL DROP TABLE #SourceData;

CREATE TABLE #SourceData(

Name...

The If_x0020_Other does not add a level as it is the sibling of the Delivery_x0020_Method node, therefore the query is the...

jbalbo (9/26/2016)

---

Hi

I use :

CROSS APPLY Data.nodes('/Data/Delivery_x0020_Method/Service_x005F_x0020_Note_x005F_x0020_additions_Delivery_x0020_Method_Option') m(Node2)

WHERE ( Node2.value('Checked[1]',...

Quick suggestion, use WinHttp.WinHttpRequest instead.

😎

Here is an example previously posted on this thread

CREATE function [dbo].[GetHttp]

(

@url varchar(8000)

)

returns varchar(8000)

WITH EXECUTE AS OWNER

as

BEGIN

...

No, a session cannot deadlock itself and there are two different spids in there, spid="186" & spid="200".

😎

On the other hand, this looks like a multi threaded Entity Framework application...

YAA (Yet...

Luis Cazares (9/26/2016)

---

mw112009 (9/26/2016)

---

Eirikur Eiriksson:

Sorry, but the first 2 entries in your solution should not be there. The output that I wanted will have exactly 3 "\" characters included.

I will...

Quick alternative to Luis's fine solution

😎

IF OBJECT_ID(N'tempdb..#t') IS NOT NULL DROP TABLE #t;

CREATE TABLE #t( pathx VARCHAR(400) ) ;

INSERT INTO #t ( pathx ) VALUES ( '/CaseRateAnalysis/');

INSERT INTO #t (...