You can see that in the first two rows of the result set.
Second, setting the default locations requires a restart of the SQL instance for the changes to take effect.
By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.
It is important to note that updating these locations will NOT migrate the current data and log files to the new directories.
But my code has such error: "vb6 error: Row cannot be located for updating.The reason why is because the default locations come from reading registry values.Applies to: SQL Server 2012, Windows 8, Windows Server 2012. Above you will find the first set of Setup Support Rules.You cannot use an update query to add new records to a database, or to delete entire records from a database.To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.