Copy, Paste and Run....hope this helps....:-)

Your query included with the three columns -

SELECT table2.column_code2,

table2.column_description2,

table2.column_code1,

table1.column_description1,

CASE WHEN column_code1 = 'RO1' AND column_description2 = 'PDF/ECOPY' THEN 'ONLINE'

WHEN column_code1 = 'RO5'...

Just to re-cap....the issue is as follows -

> I have a SSIS package which connects to multiple servers

> It executes properly when directly executed from the dtsx file (double click...

Additionally, changing to local system account is out of scope for me.

I have the same problem -

Unable to start execution of step 1 (reason: Error authenticating proxy Domain\WindowsID, system error: Logon failure: unknown user name or bad password.). The step...

Before devising a BCP / DR approach, you need to thimk of a number of aspects....

> In a failover cluster, it is a mere disconnection for the end user; in...

There are always ways to avoid CURSOR.....but you might end up in a costlier plan.

If you have decided to use tally table.....try it out....

Unless someone uses a feature or command...

> Create a Windows Security Group; the DBA Manager can be the owner

> Add all the member Windows Account to the group

> Provide SA permission to the Windows Security Group

>...

Here is a summary of activities that could be done in these type of errors -

1> If you deleted the Encryption Key and do not know what to do, and...

This post was really helpful as I have done all the tricks specified by the MS site(s) without any result.

Is there any valid explanation for this.

My assumption is that whenever...

Setting up a subscriber using a backup -

1> Setup the publication, if not already setup, as usual.

2> Restore a latest backup of the publishing database as your subscribing database.

3> Setup...

While setting up your replication you surely can use a subscription with no syc......for this typeof setup, only new data will be moved.....

Pitfalls -

1> Sometimes the replication stored procedures are...

If in a situation, wherein it is not possible to change the schema, use ur logic to checkout the same.

One of the way is -

If ur database is relatively small,...

i have scripted one of the objects from the publisher and the same was generated with box brackets. I applied the same on the subscriber database directly. Now the two...

Help...Help....Help....