I found the article little wordy (nice article though), wish you could add some pictures (may be visio diagrams) explaining some of the things described, which would have made the...

If you think your data is corrupted, look for DBCC CheckIdent

1. Why dont you write a SQL Job that will keep deleting the rows in smaller chunks & let this JOB keep running

2. Watch the pattern of rows based on...

Hope this helps (please note, I have NOT tried this, so you will have to do some testing)

1. Using "Query Analyzer" OR "SQL Server Management Studio" connect to your SQL...

My preference always has been INSTALL everything from the very beginning, INSTALL patches/Service Packs regularly on all of them (SQL Server, SSIS, ...) all those that you feel will be...

In SQL Server 2005 they added "Auditing Logon" feature (http://www.sqlprof.com/blogs/sqlserver/archive/2008/03/29/auditing-logins-in-sql-server-2005.aspx)

We can also add/use this feature to ensure the user DOES NOT take way too many connection too. Not sure if...

1. Can you please provide few more sample of the 2nd parameter value; currently you mentioned the value as "English", what other values are supported

2. Where can we get a...

If you want to run multiple SP's at a time another option would be SQL Jobs. Each job can fire individual SP & finally LOG the completion status into some...

Running multi-instance (2 in this case) of SQL Agent, hmmm. Isn't that a BUG in SQL Server? 

May be I'm wrong.

Is your package itself holding a lock on that file by any chance?

Hey Bhushan

Follow these steps:

1. Ensure nobody is using the Database, for this you might want to use sp_who OR sp_who2 stored procedure, if there is anybody using this DB than you need...

This is what i get, may be I'm missing something. Any help?

dbcc useroptions

Set Option                    Value     

-----------------------------------------

textsize                      64512

language                      us_english

dateformat                    mdy

datefirst                     7

quoted_identifier             SET

arithabort                    SET

ansi_null_dflt_on             SET

ansi_defaults                 SET

ansi_warnings                 SET

ansi_padding                  SET

ansi_nulls                    SET

concat_null_yields_null       SET

(12 row(s)...

Just like you did Table filtering, may be you can try ROW filtering for this ver table and upload chunk of data at a time (I believe its one time...

IMHO, the count of DB Objects (150 * (3+3) ) does not really matter in a long run.

1. How often anybody changes the SCHEMA for a table, which means Trigger change should...

Another option would be

1. Create "Main" Package

2. Create "Child-1" package, which will do SQL-SQL data transfer

3. Create "Child-2" package, which will do SQL Update Stuff (Linked Server task)

4. In "Main" paclage, call...