The default setting for truncation is failure / error.

from MSDN:

Fail Component The Data Flow task fails when an error or a truncation occurs. Failure is the default option for an...

BOL citation:

FOR ATTACH [ WITH < attach_database_option > ]

Specifies that the database is created by attaching an existing set of operating system files. There must be...

I'd use Slowly Changed Dimension transformation - much simpler for support / development / performance optimization / etc.

I mentioned Visual Studio 2010 Ultimate or Premium Editions.

It has everything you need now - don't wait for 2012:-)

The only problem - no multi-sever deployment tool

Very long discussion... Visual Studio was mentioned just once I'd say...

Why do not use Visual Studio Database project functionality (with any code version control system)?

Use normal build functionality, get *.DBSchema...

Brandie Tarvin (2/4/2011)

---

Toreador (2/4/2011)

---

But given that the date does exist in many other countries, SQLServer...

Executed without any problem as it was expected :unsure::Whistling:

Cannot add screenshot 🙁

What's the trick - missed point 🙂

Just wonder about user data meaning. If I have user defined table it means that it keeps user defined data.

Here the very simple example of filtered index on computed column

CREATE...

There is a simpler alternative for using Script Task for emailing - just use Execute SQL Task with the following code

EXEC msdb.dbo.sp_send_dbmail @recipients='name1@example.com;name2@example.com',

@subject = @Subj,

...

Hugo Kornelis (8/26/2010)

---

da-zero (8/26/2010)

---

I do not really understand how the scope of the type variable works. It seems you can define it over and over again, without an error being...

Nice one:-)

We need more BI questions:-)

Thanks

michael.kaufmann (7/22/2010)

---

Wayne,

first of all thank you for compiling a QotD.

However, I do not quite agree with the solution.

'Unique' is just taking the definition of a clusterd or non-clustered index a...

What about situations when you need table with the only row 🙂

Logically thinking system...

Thanks a lot! Great article!

JosephDMarsh (2/5/2010)

---

I chose 4, but (as it turns out) I was guessing. (I thought I knew what was going on, chose an answer and clicked 'Submit' before actually studying...