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 |
|
taylo
Yak Posting Veteran
82 Posts |
 Posted - 2001-07-18 : 23:31:48
|
| Hi allI have had this problem since the beginning of time. When I move an SQL account I sometimes am allowed to move all the data and the stored procedures. Other times I am denied. I am trying to do it right now. I am receiving the following errorLogin failed for user 'fooman'But it still copies the tables!This is not my SQL server. It is with an ISP. When I open the database I am trying to copy data from the tale ownership is under my user name and so are the stored procedures. So why is DTS telling me I am not authorized?Rob |
|
|
|
|
|
Deny Transfer of Stored Procedures