I have a table which stores date per week. I am passing those dates to my inline statement (in execute sql statement).

Thanks. Another question. I have a for each container that reads dates from the table. Inside the container, I've execut SQL task. I did the parameter mapping and seems like...

Thanks. I like to understand though, how a partioning table helps in archiving? I understand data gets horizontally partioned based on the partition function with partition number; but how...

Thanks. I am able to create the partion now. Now I have two concerns.

1) Dropping the existing clustered index and making it non clustered; won't it have impact on the...

Sorry, I didn't say it correctly. The underlying index supporting the sets of primary key (on few columns) is clustered. So, does this need to be made non-clustered? Because I...

Currently, my table has different sets of keys. Can theses remain intact? Or do I need to create date as primary key?

Archiving the data is also what I am trying to achieve as well.

db_owner role

Thank you all for your input.

They need to be able to run activity monitor on that db, take backups, restore only on that db.

I still don't understand how that user has admin rights on that db. That will only make db-owner I thought. Can this user run activity monitor and all? Sorry I...

So, the login should be granted sysadmin role?

Yes it does. And actually it worked again after re-processing the cube with the columns disabled from browsing...But I am not sure what the issue is...I just don't want the...

Take off line - Modify file and then take online worked for me. Thanks!

Never mind. Got it. It was under the database settings.