Finding list of objects in Sql SERVER 2005

List All the tables: SELECT * FROM sys.Tables List All the Views: SELECT * FROM sys.views List All the Procedures: SELECT * FROM sys.procedures; List All the tables with Primary key columns: SELECT i.name AS IndexName, OBJECT_NAME(ic.OBJECT_ID) AS TableName, COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName FROM sys.indexes AS i INNER JOIN sys.index_columns AS ic ON i.OBJECT_ID = ic.OBJECT_ID AND i.index_id = ic.index_id WHERE i.is_primary_key = 1 Advertisements Continue reading Finding list of objects in Sql SERVER 2005

SSIS Error – Microsoft Visual Studio is unable to load the document

SSIS Error – Microsoft Visual Studio is unable to load the document. I installed SQL Server 2008R2. I click on BIDS under Allprograms–>BIDS and click on file–> new project–>Integration services project1–> got the below error Microsoft visual studio in unable to load this document. To design integration services packages in BIDS integration services has to be installed. But I am very sure I have installed … Continue reading SSIS Error – Microsoft Visual Studio is unable to load the document

Benifits of Qlikview

Qlikview11.2 Service Release 2 provides: Use of an in-memory data model Allows instant, in memory, manipulation of massive datasets Automated data integration and a graphical analytical environment attractive for customers Fast and powerful visualization capabilities No need to build DWH Ease of use – end users require almost no training Highly scalable – near instant response time on very huge data volumes Fast implementation – … Continue reading Benifits of Qlikview

Visual Intelligence – An error occurered: The engine failed to start before timeout. Restart the application. (HDB 10005)

Visual Intelligence 1.0.5 was installed and working flawlessly. Throwing the error when trying to acquire from CSV,xls, Free Hand SQL, or Universe; An Error Occured: Data Source creation failed / The engine failed to start before timeout. Restart the application. (HDB 10005) Continue reading Visual Intelligence – An error occurered: The engine failed to start before timeout. Restart the application. (HDB 10005)