Archives
-
SQL Server 2008 Management Studio: Saving changes is not permitted.
In SQL Server 2008 Management Studio, saving changes to the design of a table that requires the table to be dropped and recreated is not possible, but will show the following message instead: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either [...]
Dec 25th, 2008 | Filed under SQL ServerTags: data, SQL Server -
Error publishing an InfoPath Form: The following URL is not valid.
Today, I tried to publish an Infopath Form to MOSS, but I received the following error message: The following URL is not valid: http://servername/sites/sitename Different solutions are available for this problem, but in my case the cause seemed to be that there was no root site (http://servername). So the solution was to edit the site [...]
-
Import Excel files with SQL Server Integration Services on a 64-bit server
Today I deployed some SSIS packages to a test environment. These packages needed to import some excel files to a certain database. Testing the packages resulted in the following error: Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0×80004005. An OLE DB record is available. Source: “Microsoft JET Database Engine” Hresult: 0×80004005 [...]