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...

Duplicate post, answers in the other thread please!

😎

scarydba (7/21/2014)

---

I am trying to upgrade SQL 2000 reporting services to SQL 2008. I backed up the ReportSever and ReportServer TempDB and restored successfully, However when I try to restore...

It is better to break down the problem into smaller parts using nested case statements, more readable and easier to follow. Here is an example which should be close to...

previn1980 (7/26/2014)

---

Sorry if I do not understand.

So, SSDT is an integrated CLIENT tool in Visual Studio which replaces BIDS for develops etl packages/processes. Is it right?

If so, what's the...

GilaMonster (7/26/2014)

---

Before you apply compression to everything, test and make sure that the CPU overhead is acceptable. On page compression it can get nasty. Also don't compress indexes unless you...

Didn't take long :blush:

Thanks!!!

😎

previn1980 (7/26/2014)

---

Eirikur Eiriksson (7/26/2014)

---

First of all, welcome to the forum. SQL Server 2012 has a new approach to the Business Intelligence via the Data Tools, look for SSDT instead of...