As in where it is stored in msdb.

For the highlighted package the comand line to delete...

In the Process Tab:

1. Instead of setting Executable to C:\ePLUM\bin\ImportAll.bat, set it to fully qualified path to cmd.exe (e.g. C:\WINDOWS\system32\cmd.exe on my workstation).

2. Set Arguments to /C "C:\ePLUM\bin\ImportAll.bat"

In your Exec Process task you may have to pass the location of the batch file as a parameter to cmd.exe. Check out the /C switch, from a cmd prompt:

cmd.exe...

How are you opening BIDS initially? I have seen different entry points into Visual Studio offer different menu configurations.

If all else has failed, have you tried resetting your environment by...

Try it with backslashes:

Embarcadero DBArtisan

If you want the subscriber to reflect change immediately, you want Transactional Replication, not Snapshot Replication.

Transactional Replication Overview

I could have misread, but I took it to mean the OP needs something like:

SELECT ContactID

FROM Person.Contact WITHOUT (INDEX(AK_Contact_rowguid))

which, oddly, yields no results from Bing 😀

Your log chain will be fine, but it will not help your log file size:

http://blogs.msdn.com/b/sqlserverfaq/archive/2011/01/07/using-bulk-logged-recovery-model-for-bulk-operations-will-reduce-the-size-of-transaction-log-backups-myths-and-truths.aspx

Is it a clustered index, or nonclustered?

If nonclustered a simple way requiring no knowledge of the index definition:

ALTER INDEX index_name ON schema_name.table_name DISABLE ;

-- Rebuilding the index re-enables it

ALTER INDEX...

One option to safely rid the database of one of the two overlapping indexes is to INCLUDE the third column in the unique index. Included columns are not considered in...

I include msdb it in my index maintenance job. It does not require downtime, it may just block other processes while the indexes are being rebuilt...a normal side effect of...

Anytime, thanks for posting back, happy to assist 🙂

Can you use transactional replication to bring data into scope, but into a different schema where you can add indexes? Know that it is possible to replicate data in one...

The top 5 targets I look at when trying to improve performance are:

1. queries

2. queries

3. queries

4. indexes

5. schema

It sounds like you cannot change any of those.

If by chance you're having...