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 too. The ability to do bulk inserts (which the public permission permitted previously) is no longer part of the public permission. As the administrator, you explicitly define this permission. If you do not define, when you create a mart using a SQL Server 2005 database, and save it, an error appears.
Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |