I had the same problem and this is how I fixed it.

1. Make sure the Full text catalog service runs as on the same account as the sql server.

2....

Hi Lynn,

Thanks for the link. I was reading that article a while ago.. but trying Sarabpreet solution in parallel :-).

Thanks,

Brijesh

the reason I am trying previous month is because we keep 30 days calender months worth of data.. but some times we do tend to keep more then 30 days...

Hi,

I really really appropriate you taking time to write up all the code. I works like a charm for this month. But If i try to insert data from previous...

I just remember one more thing. If use ur function when I get data for next month it won't work because the function will try to find something with

08-14-2009...

Hi,

Thanks for the function and it works good till I reach 13th date.. after that for some reason function blows up and below is the error message I get

Msg 7705...

I did think of using your your function but the problem is you are using "int" as the partition function parameter where as my column is in date time format...

Thanks for reply but I guess u didn't understand my question

I can create partition based on Month or day of the year. But I want partition based on date...

If your maintenance job is not deleting the files then just add and del command using sqlcmdtask add the below code.

xp_cmdshell 'del c:\.......\*.bak'

This will automatically delete the .bak contents...