Hi Phil,

It goes further and the script component seems to works ok.

I've check the value inside the script component using:

System.Windows.Forms.MessageBox.Show(varCollection["User::theVariableToWriteTo"].Value.ToString());

and the value's right.

But the variable at the package level is...

Yes it did the trick!

Thank you sdevanny.

Hi sdevanny

I'm in the middle of deleting the Union All component and recreating it.

So far it seems to solves the problem. Still I'm doing more verification to make sure I...

If the security's tight (which is rarely the case, from experience taking on new DB), in SQL you can track who has the ALTER DATABASE permission.

But most of the times...

It has been told a couple of times already but I feel the same way

1-

The featured contents should be put back at the top of the letter so that a...

I've got my own answer.

Double quotation marks "" are implicitly added around the parameter which provoke the parsing error once the query is fully assemble.

I know most will disagree with what I will say but that's what I found through out my experiences.

If there's no money tag associate with something (downtime, results, etc) then...

I would go with what Sean Lange recommend first.

In no particular order:

Try #1:

If you can I would change the table convert data type to VARCHAR(26) and check the performance result...

Our customer base still mostly runs XP and they don't plan to upgrade their OS soon. So we go where the money is therefore we will stay with 2008 R2...

To my eyes, those two comes up with the way I feel are the best.

One from Phil Factor:

https://www.simple-talk.com/blogs/2009/01/22/technical-interviews-and-tests-have-got-to-stop/]

And the other from Grant Fritchey (Half DBA oriented):

http://www.scarydba.com/2012/09/24/interviewing-a-dba/

You get a call from...

Temporarily, I've dropped and recreated all custom assemblies which used the specific .Net Framework 2.0 DLL in the database and it works.

This is a workaround and not a fix but...

Meanwhile, I've found my answer:

Restoring a log backup rolls forward the changes that were recorded in the transaction log to re-create the exact state of the database at the time...

Angel,

If I remember correctly (from experience only I don't have anything to back this up) sql_dependencies isn't able to report all dependencies (flaw or by design?).

SSMS use this for the...

Interesting script thank you.

However there's two things that came out very quickly.

1- The script's does not take into account the schema which is a drawback in our environment because it...

Thank you MysteryJimbo