Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpan
Starting Member
7 Posts |
 Posted - 2004-11-23 : 10:27:35
|
| I have a DTS package that exports two tables from one SQL server (server A) to another (server B). On server A both tables have their persmissions set so public can select. After the transfer to server B I get a permissions denied error when I attempt to run a select query from server B against these tables. I have to manually set the permissions on the tabels after the transfer in order to run a select query.What am I doing wrong in the DTS transfer? Why am I loosing my permissions? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-24 : 01:36:12
|
| does your dts package drop the tables before copying the data?--------------------keeping it simple... |
 |
|
|
jpan
Starting Member
7 Posts |
Posted - 2004-11-24 : 08:11:03
|
| I modified the DTS package so it will no longer drop and recreate the table. It now just replaces the data in the already existing table. This works fine. Thanks for the reply. |
|
|
|
|
|
|
Permissions