SQL Server General DBA

The Excel Connection Manager is not supported in the 64-bit version of SSIS

When you attempt to execute an SSIS package which has a Excel Destination/Source in SQL Server 64 bit , you will get following error. [Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available. As […]

Is there a difference between fill factor 0 and 100

When creating indexes in SQL Server, if you do not specify an index fill factor, the fill factor will be 0 (effectively the same as 100%). You can specify an index’s fill factor percentage in a number of different ways. Some of these methods include: The Create Index statement, DBCC DBReindex and Rebuild. ALTER INDEX […]

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created.

ERROR: “Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.” This error happens because “Saving Changes is not […]

Remove a Node From a SQL Server 2008 Cluster

Run SQL 2008 setup.exe from the node you wish to remove from a cluster (the node to be removed should be the active node), the Installation Wizard will launch the SQL Server Installation Center as shown below To remove a node from an existing failover cluster instance, click Maintenance in the left-hand pane, and then […]

Report Builder Fails to Launch

In SQL Server Reporting Services (SSRS) 2005 clicking the Report Builder option in Report Manager does not launch Report Builder Tool. You need dotnet framework 2.0 in your client machine to launch Report Builder. Verify whether you have installed dotnet framework 2.0. If it is already installed check the application log from the event viewer […]

Error when Inserting data to Replicated Databases

In a database previosly enabled for replication, upon attempting to insert records the following error is raised. Invalid object name ‘dbo.MSmerge_contents’. To resolve this, when replication is enabled, additional columns and triggers are created. When replication is removed, there are times that newly added tables are not removed. To overcome this run: sp_removedbreplication  @dbname =  […]

How to Perform Multiple lookups to the same table

In a SQL Server Integration Service (SSIS) package, when lookups are performed on tables inserted in the same package by a previous task, the error “could not match” is raised.    Above is the failed package layout. From the insert data, two records will be inserted and at the lookup those values are used to get […]

How to run SQL Profiler without sysadmin rights?

In SQL Server 2000, to run SQL Profiler the sysadmin needs to grant permissions to the user running the trace. In SQL Server 2005 and 2008, the option exists of granting permissions to Profiler so that users do not need to be a member of the sysadmin group by using the code below: USE master GO GRANT […]

How to import an Excel file which has columns with more than 255 characters to SQL Server using SSIS?

When the driver determines that an Excel column contains text data, the driver selects the data type based on the longest value that it samples. If the driver does not discover any values longer than 255 characters in the rows that it samples, it treats the column as a 255-character string column instead of a […]

How to Manually Uninstall SQL Server 2005

Sometimes, you may find that, though you can’t see any SQL Server 2005 instance in the programs list and when you try to install SQL Server 2005, you get a messages saying that there is already a SQL Server instance or some components such as SQL Server Management Studio installed. The reason for this is the existence of corrupted SQL […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |