|
|
|
For SQL Server 2000, you only need the public permission assigned to save to the mart. However, when the repository is on a SQL Server 2005 instance, you must have the bulkadmin permission designated as well. The ability to do bulk inserts (which was permitted by the public permission, previously) is no longer part of the public permission. As the administrator, you must explicitly define this permission or when you attempt to save a model to a new mart created using a SQL Server 2005 database, an error "You do not have permission to use the bulk load statement." is returned.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |