Well i try to backup and restore but it did not work. I tried by making it dbowner, putting it in db_owner role also. It worked only if we make...

Create a table with fields :

Feature_Id (Primary key),

Fk_MainTablekey ,

Type,

Id,

Status

the connection string you are using is not correct. There is nothing like 'Database name' in connection string. Use 'Initial catalog' instead of this, or for more information about connection...

Can you paste the xml that you are storing, Its always better to store the data in tables instead of using xml datatype column and search can be optimized by...

Are you creating a NEW table on a partitioning scheme?

If you are creating partition on a new table then you do not need to explicitly add the partitioning colum to...

hi,

Make that user the dbowner and then execute the job, hopefully it will work.

Good luck

You can use the dynamic SQL for this, and make sure you have turned on the set count on. and use @@RowCount to check the record count of last executed...