Hi all,
I have a strange problem with installing the Pubs database in the Guided Tour. In fact, I successfully installed it once, but when by error I wanted to install it a second time, the problem appeared.
Normally, the script tests whether there is already a copy of this database on the disk location and if so, it should drop it before the new installation. But, this does not happen (the database is not dropped). Thus, the script continue the installation that logically causes problems, namely it tries to define new primary keys for the existing tables, but these keys already exist, so error messages.
Therefore, I manually deleted the database from the disk and tried a new installation. But now, when I copy and paste the script in the command line window, it only opens and closes up directly afterward, without any installation.
I even restored the deleted database into its original location, but the problem persists and I don't know how to resolve it.
Any idea?
Thanks for any suggestion.