Thanks Lowell,

Just found a workaround for it.

exec sp_msforeachtable 'revoke insert on ? to Public'

exec sp_msforeachtable 'revoke delete on ? to Public'

It works. Thanks again.

Thanks Schadenfreude-Mei and MarkusB.

I will try it. Thanks a lot.

I got the below erros during the export/import operation.

- Execute the transfer with the TransferProvider. (Error)

Messages

ERROR

: errorCode=-1071636471 description=An OLE DB error has occurred.

Error code: 0x80040E14.

An OLE DB record...

Thanks,

Should I manually create all the tables or I can just Import/export the data?