Previous Topic: Convert or Update a Mart

Next Topic: Specify Use of Foreign Characters With Microsoft SQL Server 2000

Microsoft SQL Server 2005 Permissions

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.