I just enabled CDC on a test database to see how it creates the CDC tables. The CDC tables are created as system tables which are ignored by the...

Assuming the tables are in the same database I think you could do a query like this:

SELECT

NA.Name1,

NA.Name2,

NA.Name3,

...

I don't...

I have BIDSHelper 1.6.5.0 installed in VS 2010. Same version of VS as you have. Wish I could tell you more.

If you give write access to a subscriber changes made on the subscriber never make it to the publisher and it also will put replication out of sync. ...

When running the report in BIDS all the work (other than the database work) is being done locally on your PC. When running in IE from a report server the...

What do you mean by a header row? By definition XML doesn't have rows, it has elements and attributes.

There are several products out there. I'm in the process of trying to find out what we want to audit and then picking the tool that does what we need...

You need to provide more information. What is the schema of the table(s)? What are the queries you are running? What defines fast?

This might work:

SELECT

OBJECT_NAME(P.object_id) AS tableName,

SUM(P.rows),

DDIUS.last_user_update,

DDIUS.last_system_update

FROM

sys.dm_db_index_usage_stats AS DDIUS

...

Sounds like you want to put a query in a SQL Agent Job which will allow you to schedule the execution for whatever frequency you need.

I've never done this, but I'd try putting setting the first object in my report to have the page break property set to before.

Matteo,

What version of SSIS are you using? This article was written a long time ago and the code even longer using SSIS 2005. There may be changes somewhere...

mortonsoft (7/9/2014)

---

I am very interested in a definitive answer here... In a shop like mine where they don't want any stored procs to be used at all, and where they...

Questions posted on SQLServerCentral

Could you provide me with some idea as to what the DBA would do during the day and why they...