Browse by Tags

Interesting and useful cross-blogs

Published 17 January 8 3:26 AM | SSQA.net

Interesting and usefull cross-blogs from a fellow MVP on stored-procedures, transactional replication: Parse delimited string in a Stored procedure Exporting blank SRS report to excel does not render the headers Setting up Transactional Replication from...

Filed under: sql server, blogs, excel, reporting services, procedure, format, stored

OLAP Connectivity from Pivot Table in Excel - security permissions

Published 25 September 7 4:14 AM | SSQA.net

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, security, ssas, ssms, olap, excel, pivot, execute, credentials

SQL Server Tables and Exchange Web Services

Published 20 June 7 3:57 PM | SSQA.net

Tool: SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Exchange Server 2007 and SQL Server 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications...

Filed under: sql server, tools, exchange, client, excel