I find it is often easier to use C# to define a complex process than having a workflow with many tasks and connections going all over the place.  You can...

I would use a no-cursor, no-temp-table version that includes schema.  The value used for @QualifiedTableName can include the schema and any needed brackets.
DECLARE @QualifiedTableName SYSNAME = 'schema.table';
DECLARE...

RE: VB vs Java (why not PowerShell?) for managing extended properties.  Why use either?
You can use sys.extended_properties to view all extended properties.
If you put an INSTEAD OF trigger...

Go to Tools -> Options -> SQL Server Object Explorer -> Scripting.
I think you're looking for the "Script partition schemes" setting.

You could use this query:
SELECT    TransTableDetail_Trans_To
FROM TransTableDetail
WHERE TransTable_Description IN ('LFAllCSCW', 'LFTEST')
GROUP BY TransTableDetail_Trans_To
HAVING COUNT(DISTINCT TransTable_Description) = 2
-- If table has a unique index...

I'd still like to hear someone say why they don't use UPDATE ... OUTPUT to pick an item from the queue without an explicit transaction.

UPDATE TOP (1)...

/* Copy multiple databases via BACKUP - RESTORE
Assumptions:
    SQL Server 2008 or later (set values in DECLARE, += operator, compression, copy_only)
    URL is accessible from...

There's not enough info on the role of the id column.  If you only want unique names, and one table contains (5,"SSIS") while the other contains (12, "SSIS"), a UNION...

UNION ALL will cause each Name to be repeated if it appears in both tables.
Are the ID values significant?  If by "display the Common" you mean you only want...

If the additional header rows cause errors, you could change the error handling on the flat file source to "Redirect Row" for all columns and have them filtered out of...

Rebuilding indexes on large tables definitely causes a lot of log file activity. The rebuild will not complete if the log file drive runs out of space.

You don't...

Thanks, that solved the problem.