IRL11 (8/30/2016)

---

Thank you for your reply, I have a feeling these files may be too much for XMLBulkLoader however I will have a look at the links you sent and...

This sounds like a textbook case for SSRS subscriptions. Are you sure you want to go "old school" on this one?

https://msdn.microsoft.com/en-us/library/ms159762.aspx

Sergiy (8/30/2016)

---

Pivot-156509 (8/30/2016)

---

@matt-2 Miller (#4): no

@Sergiy, @Lynn Pettis: because the SESSION's row are delete few time after, you can see this on code. When a new row is inserted the...

Was the session table ever reseeded? If so - your history table may have id's greater than the current max SS_ID.

Pivot-156509 (8/29/2016)

---

Matt Miller (#4) (8/29/2016)

---

With all due respect - just because your log table is showing the same value from another table twice doesn't quite compute to IDENTITY() being flawed....

With all due respect - just because your log table is showing the same value from another table twice doesn't quite compute to IDENTITY() being flawed. Also - for what...

Jeff Moden (8/26/2016)

---

Matt Miller (#4) (8/25/2016)

---

I'm sorry if I am taking the fun out of building a SQL only solution, but there are lots of basic samples of SQLCLR showing...

I'm sorry if I am taking the fun out of building a SQL only solution, but there are lots of basic samples of SQLCLR showing how to expose the Regex.Matches()...

Eric M Russell (8/25/2016)

---

Matt Miller (#4) (8/25/2016)

---

SQLBill (8/25/2016)

---

Eric M Russell (8/25/2016)

---

I'm not surprised that a small group of students could take a public dataset and spin up a better application...

SQLBill (8/25/2016)

---

Eric M Russell (8/25/2016)

---

I'm not surprised that a small group of students could take a public dataset and spin up a better application than the original government IT contractors....

mister.magoo (8/24/2016)

---

Sergiy (8/24/2016)

---

mister.magoo (8/23/2016)

---

To answer your question about how (not getting involved in why)

declare @x xml;

select @x=(

select ''+b

from

(

select 'hello;friend'+CHAR(13)+CHAR(10)

union all

select 'my;world'+CHAR(13)+CHAR(10)

)a(b)

for xml path(''),type);

select @x.value('(./text())[1]','nvarchar(max)')

the important things are to use...

Might help if you were to explain what you're doing. using service broker to send dynamic SQL is a truly strange way to use it.

I can't tell...

(removed - already covered previously in the thread).

Depending on how strong of a lock you want - the low end could be as simple as putting up a schema-bound view that references the table you don't want...

Sergiy (8/22/2016)

---

ben.brugman (8/22/2016)

---

So my script does not produce the errors your script produces. So your conclusion based on your script and your error is not a valid conclusion. (Even if...