Okay, my post above looks strange to me.

Sample code for you to play with. You will need to put the data into a text file, and be sure to modify the line where I have the...

Here is more code for you to take a look at and play with.

CREATE TABLE [dbo].[MainTable](

[DrugName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CalendarYear] [int] NULL,

[CalendarMonth] [int] NULL,

[CalendarQuarter] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[PatientID] [nvarchar](255) COLLATE...

The UDF is a Dynamic Tally table. Take the time to read the second to last article I reference below in my signature block regarding Tally tables. You...

Nardig (6/30/2009)

---

ok i have one table with MemberID, Name, Surname and City and information for inserted on this table and i have on text file for example 1001, John, Smith,...

Not a replication specialist, but it looks like there are replication transactions that have not yet replicated to all subscribers. How space is bein used in the T-Log?

You already have a thread open regarding this here.

Do not post responses here.

I have no idea. You haven't provided us with anything to work with here.

Gianluca Sartori (6/30/2009)

---

... if I ever come to an end!! I'm quite busy in these days and tomorrow I'm taking my wife to the hospital for the birth of my...

Give the attached code a try. You need the code in both files.

Are you entering any values into the Notes column during this process?

Differences in the query engine. Perhaps in SQL Server 2000 the WHERE creteria ISNUMERIC(...) = 1 may have filtered records out before the creteria with the CONVERT on it...

What is the recovery model of the distribution database?

Just curious, but, since you are using litespeed are you compressing your backups?

Gail, you'll like this one. The OP wants us to use our crystal ball to help solve his problem.

Don't know about you, but mine seems to be permanently cloudy.