You can do it with the wizard, there's no need for an example.

Open SSMS and connect the target database (SQL 2005), right click the database name, select tasks --> import...

Not enough information here.

Please read the article linked in the first line of my signature. You will find out how to post effectively and get an answer quickly.

If you want to do the exact contrary, check out this Visio Addin by SQL Server MVP Alberto Ferrari: http://forwardengineer.codeplex.com/

I don't think BCP is the right tool for this task.

Have you considered using SSIS?

I don't know if these tools do exactly what you're after. Give them a look:

1) Er-Win

2) Visio

I'm sorry. Here's the revised version:

SETUP:

DECLARE @Table1 TABLE (

ItemID int,

ItemName nvarchar(100),

...

Performance Guard, I think you misread the question.

We're not talking about performance monitoring, but (mostly) DDL change tracking.

OK, and what is supposed to go into the e-mail body?

All the columns? If so, I think that the XML solution is not feasible: you would have to convert and...

It could also be done with DDL triggers (I have done this in the past), but this is not the point.

When it comes to source control, I must admit that...

Grant Fritchey (10/4/2011)

---

But then you build the system to allow the drill-down to make another query. I've been through this too, at multiple organizations with multiple different data sets. There...

Nevertheless it was fun to code!

I wish it was...

Mark-101232 (10/4/2011)

---

WITH CTE AS (

SELECT [Index],Value,Stamp,

ROW_NUMBER() OVER(ORDER BY [Index])AS rn1,

ROW_NUMBER() OVER(PARTITION BY Value ORDER BY [Index])AS...

Perfect. Glad I could help.

Non c'è di che 😀