Partition on table with no data and table with data

• kalyav21

  Right there with Babe

  Points: 785

  More actions

  August 13, 2013 at 4:34 am

  #276874

  Hi,

  I have a table created and as of now there is no data in the table, I created a partition view on this table based on the paiddate field. Then I have loaded nearly 3months of data in the same table where partition was created. then I checked the sys.partitions for the same object, but the rows in sys.partitions is not matching with the no of rows in my data for the paiddate.

  How can I check my partition is working correctly or I can drop the partition function and recreate it again. Please advise

  Regards

  Kalyani

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  August 13, 2013 at 4:10 pm

  #1641181

  Do you have a paritioned table or a partitioned view? Can you post the scripts for what you have, so that we can understand what you are talking about?

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]