Browse by Tags

Pivot table connectivity to SQL Server Analysis Services - security gotchas
14 March 08 06:10 AM | ssqa.net | with no comments

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...

Filed under: sql server, permissions, security, analysis services, ssas, pivot, excel, office, olap

SQL Server 2005 Replication: What are the Schemas and how they are replicated?
15 February 08 09:28 AM | ssqa.net | with no comments

You may be aware SCHEMA carries 2 different meaning within SQL Server 2005 version that were introduced, first one is the definition of an object (object.schema) and next one is owner of an object (user.schema). In the first case replication copies the...

Filed under: sql server, server, users, permissions, replication, object, security, stored procedure, schema