For "kahmeal"

perfect answer: Once I gave write/modify permissions to the account running distrib.exe for the folder in the error message, the subsequent attempt to initialize replication completed successfully.

For sustainability and maintenance, I demand it of programmer. IF NOT then the code get rejected at Code review. NO EXCEPTIONS. Either do the job right or get out...

I second that recommendation to fix PostalCode 03054 to PostalCode 030564.. Just a Typo. That proves people did read the article.

Excellent Post,

We are going to consider it in our SSIS development group.

Thank Johan...

Hank Freeman

Edward, thanks for such a well WRITTEN article. You have raised the bar for others who post at SQL Server Central.com.

Five Stars !

Hank Freeman

SQL server DBA/Data Architect - Atlanta, GA

:smooooth:

The code faulters with this error

Lookup Error - SQL Server Database Error: Divide by zero error encountered on line 154

the start of the select query

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

--Main Query: Final Display / Output

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

SELECT

...

Here is an example of my code which is working... The Error line you see below has a comman delimiter so I can produce the error because the CSV file...

Thanks so very much for this insight... Save the day, the bacon and several sleepless nights that were yet to come.

FYI ! --> Please make a spelling change...

Thanks so very much for this insight... Save the day, the bacon and several sleepless nights that were yet to come.

FYI ! --> Please make a spelling change...

This is an interesting topic, which needs further discussion. As an example I have several tables that have duplicated foreign keys to the same relationship. When resolving system generated foreign...

Here is one of my favorite script that does what you need for one database at a time with a preceeding USE dbname... So if you want to do this...

Jeff,

I agree with you and I believe that encryption keeps competitors just that.

Take Quest LiteSpeed for SQL Server as an example. It is evolved into one of...

I have a solution to the @TargetSize in my script... Which I am testing.

Boris and Others.

Boris, I have taken your concept and fixed at few issue as already reported and have put in some new features. So before I post them on...