Yes I understand your points, there's not a solution that will fit for every problem.

If I could have time I would expand your queries to add a weighting mechanism for...

First thanks for the scripts, they will surely help me on some occasions. (the one that get the dependencies instead of viewing them in the tiny box in the enterprise...

For my problem there's a solution, but I don't want to go that path. Code a merge replication engine using .Net with all the needed features. A complete manual feature...

Thanks but that is to prevent outside from listening on the wire while data is transmitting. It is not what I'm looking for on that issue. (Still I do concern...

Ugh, wrong forum and it didn't seems to be "deleteable" even using the "delete" button :blink:

I believe you can use the stored procedure sp_serveroption to configure your linked server collation setting.

Check the options: "Use Remote Collation" and or "Collation Name"

Regarde l'aide sur la commande "Process.Start(process as string,options as string)", ça devrait t'aider pour lancer l'exécution de ton package SSIS.

Et voici la syntaxe pour utiliser DTExec:

C'est maintenant à ton...

Autre détail aussi, tu peux afficher une partie de ta requête sur [/url]. C'est l'endroit (mon opinion) ou tu pourras trouver de la très bonne information avec des gens très...

La façon que je perçois le tout serait d'utiliser la commande dtexec avec les paramètres requis pour ton package. C'est une commande de style "DOS" (command line) que tu pourras...

I've been reading book 70-444 and it contradict 70-443 for Unicode data types.

IMO I believe 70-444 has the right answer. When using Unicode, it take 2 bytes for each character.

I've...

Never used LINQ directly but my main concern is how well LINQ will integrate? How LINQ's know how to form an efficient SQL query. I don't think it uses a...

To go to advanced options, you must look for a small check box at the bottom of one page configuration. It state that you want to have advanced options when...

Did you check DDL triggers?

They might help you doing what you want.

You need to check also if the apps can connect to specific instance if you want to consolidate. If they only connect using the machine name (instance less or the...

Could a UDT be used in this case?