check dependcy on the table whether it is having trigger for insert.

also if possible script out the table send to us or check the script itself whether it has identity...

sorryy my mistake..

i have added the user db_ddladmin now he able to access

thanks for replying

i have limited rights..

actually some time back we remove alter and exec permission the user, now i have given back the alter and execute permisssion. but earlier this user was...

hi actually i tried to user tidb_ddladmin role but i dont have permission to do that.

is there any other alternative to do it?

like we do grant alter to [domain\username]

i am not clear about what you trying to do?

Are you trying to add new step in existing job created for SSIS package execution

I wish josef Speedy Recovery.

Regards

Ramu

strange error,can you post the error snap shot... what of right do you have on server where u r creating maintance plan.

are you trying completly new Maintance plan or you...

strange error,can you post the error snap shot... what of right do you have on server where u r creating maintance plan.

are you trying completly new Maintance plan or you...

asif.2.mujawar (11/12/2009)

---

Hi Joie,

Actually proposal for DR is to implement replicated SAN. As you said both servers having same instance name. which is what i am trying to restore the...

restoring master and msdb will give you all user login and job linked server etc which where present on old server

Regards

Ramu

use datepart function to get the time part of the date convert it to varchar and concatenate to you date string

thanks

Ramu

i am sorry the post was for different topic.

could please tell us which anti virus software your production server is having.

Regards

Ramu

could please tell us which anti virus software your production server is having.

Regards

Ramu

yes u can ,there is option in schedule of job called after every ___ hour starting at and ending at.

Regards

ramu