Hello

I am about to start research on SQL 2005 partitioning for our project, we are currently using LLBLGen Pro in our project. Will the generated code work with partitioning? Since it looks like a table does it behave like a normal table? Or will I have problems with this.

Please let me know.

Thank you, Bruno

What kind of partitioning are you considering? What's the type of data we're talking about (archived data, live data etc. )?

I am talking about this kind of parition: http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm#_Toc79339948

using range to divide my data by date of transaction.

As far as I understand, the partitioning is done on the physical level, but logicaly the table is still intact. So my conclusion is that a partioned table will be used as a normal table.

Thank you.

I will continue my research. When I have a working system I will let you know the results.