Wow... It works.

Thanks David.

It's fixed. the day is wrong. it should be 30 not 31.

ALTER PARTITION FUNCTION PFCLHFunction()

SPLIT RANGE ('2010-06-30 23:59:59.997')

GO

I did a little test. I ran the following query on SQL 2000 and the same query on SQL 2005.

I get error when I run the following query on sql...

I meant to say my other table row size is 12940

Correction in my question.

There is no varchar(max) and image type in the table. I know when you calculate the size of the row then we have to exclude the size...

Here you go.

ColumnName Type Computed Length Prec scale

GROUP_ZZintno410 0

PATIENTnumericno912...

Thanks guys, It's done, It took little time though

Thanks for the reply Alex.

I checked the constraint and all are correct.

I also add NOT NULL in the check constraint but still getting the same error. Don't know what is...

Thanks Phil, Yes it is the problem, I might creating custom script to load data,

Did not get any reply but I did figure out the way but there is little issue in that.

Steps created in SSIS package to import data from multiple tables,

1. Placed...

How can I do this in SSIS package ? Is there any article about this.

I have to pass two parameters in the query, ClientID and Date to filter the query.

for example there is a table called ClientInfo and have following values

ClientId ...

Problem is solved.

Actually, there were two variables created on SSIS package, one is Date and other one is Client and when I mapped the date variable with parameters, it was...

here is the error , I am getting.

[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record...

You guys are right, I just checked and found that db-reindex are running on those partition tables and growing the size of filegroups.

One more thing I noticed that DB-reindex is...