Category: SQL

SQL

How to delete and regenerate a foreign key object

Posted on

Last a college asked if it was possible to delete a foreign key object and regenerate it from the original database. His database objects where dossiers and clients. Client are managed in another application. Therefore it was needed that he could throw his clients table away and regenerate it with the latest version of the […]

SQL

Problem installing SQL Server 2008 on E Drive

Posted on

Recently I tried to install SQL Server 2008 on the E drive of my server. It went totally wrong when I tried to change the installation path to my E drive. The error “The INSTANCESSHAREDWOWDIR command line value was not specified. The value must be specified when …” entered the installation process when I changed […]