michael_alawneh (7/28/2014)

---

I am running SQL Server 2012. I have been producing files as output for the Unix folks at work. We are running into an issue with what appears to...

Grant Fritchey (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Koen Verbeeck (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Ed Wagner (7/28/2014)

---

SQLRNNR (7/27/2014)

---

So...

The way around it is to work with the XML in smaller parts...

Quick thought, 80 outputs is quite a lot, it might be worth looking into XQuery in TSQL for shredding the XML.

😎

I have done few of these huge XML imports in...

Guitar_player (7/28/2014)

---

Actually i am inserting and updating into the Staging table only from Oracle and then we are building a Dimensional Data warehouse upon that ..

But here i am Inserting...

Guitar_player (7/28/2014)

---

Hi ,

I need some info. about the Insert and updating the Records from Oracle Table to SQL server table using the SSIS packages and Attunity as...

diallonina (7/27/2014)

---

Oh Eirikur Eiriksson, i am impressed by your script :w00t:

In your sample, you are listing the colums of the table to audit and if this table changed (column added...

Before going further, I recommend that you read through the documentation, see this link: Change Data Capture and then come back with any questions you may have. It will take...

Sorry, should have included this in the previous post:-)

😎

Run this query

SELECT @@VERSION

The last line of the output will tell you, here is an example

Microsoft SQL Server 2014 - 12.0.2000.8 (X64)...

spectra (7/27/2014)

---

We are deviating from the solution.

its a SQL Server 2008 General sub forum ...right ? version is of course Sql...

spectra (7/27/2014)

---

Eirikur Eiriksson (7/27/2014)

---

This can be done, check Features Supported by the Editions of SQL Server what is available for your SQL Server Edition.

Suggest you have a look at these...

You can use "dynamic" sql,...

spectra (7/27/2014)

---

Hi,

Is it possible to enable CDC on all tables in the database ?

also is it possible to find which tables are changed ? and find changes from...

Thanks Lutz, I was thinking about revisiting it for the getdate:-D

😎

There is a much simpler way of doing this and it also allows for multiple multi-row actions, the COLUMNS_UPDATED makes that difficult (tip: if there is a variable in the...