SQL Server upgrade from Express

To upgrade SQL Server from Express edition to a different edition of the same version follow the steps:

  1. Insert the SQL Server installation media of the new edition you want upgrade to. From the root folder, double-click Setup.exe.
  2. SQL Server Installation Center click Maintenance, and then select Edition Upgrade.

Did my HOW TO help you? Leave a reply.

HOW TO know the SQL Server version installed

There are different methods how to know the SQL Server version installed.

My preferred, for me the easiest to remember, is run the following query:

Select @@version

An example of the output of this query is as follows:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition (64-bit) on Windows NT 6.1  (Build 7600: )

For further info, please, use the reference link.

Reference: How to determine the version and edition of SQL Server and its components

Did my HOW TO help you? Leave a reply.

HOW TO take offline a database in SQL Server

HOW TO take offline a database in SQL Server?

Microsoft Sql Server Management Studio

Right click on the database node > Tasks > Take Offline

T-SQL Script

Execute the following query

ALTER DATABASE [DatabaseName] SET OFFLINE WITH
ROLLBACK IMMEDIATE
GO

If it seems that the command doesn’t work or the execution requires more time or to force to take offline or

if you’ll receive the following error:
ALTER DATABASE failed because a lock could not be placed on database ‘{DatabaseName}’. Try again later.

click on the following link to show the Solution:
ALTER DATABASE failed because a lock could not be placed on database

Did my HOW TO help you? Leave a reply.

ALTER DATABASE failed because a lock could not be placed on database

ALTER DATABASE failed because a lock could not be placed on database ‘{DatabaseName}’. Try again later.

Cause:
One or more processes regarding {DatabaseName}, also in sleeping status, are blocking your query

Solution:
Execute

EXEC sp_who2  --or sp_who

to know the list of SPIDs’ processes where DBName is {DatabaseName}
then execute the following command for each of them to kill these processes

KILL {SPIDNumber}  --e.g. KILL 55

Now finally you can execute your query to ALTER the database.

Did my solution solve your problem? Leave a reply.

TableData 2000000001 does not exist.

—————————
Microsoft Dynamics NAV Development Environment
—————————
TableData 2000000001 does not exist.
—————————
OK
—————————

TableData 2000000001 does not exist.

TableData 2000000001 does not exist.

Cause:
You’re trying to open a database using Microsoft Dynamics NAV Development Environment but the user hasn’t the Role Member db_owner for the database in SQL.

Solution:
Grand the user to db owner using SQL Server Management Studio.

db_owner

Related Post: TableData does not exist

Did my solution solve your problem? Leave a reply.

You do not have permission to read the Change Log Setup table

—————————
Microsoft Dynamics NAV
—————————
You do not have permission to read the Change Log Setup table.

—————————
OK
—————————

You do not have permission to read the Change Log Setup table

Cause:
The customer doesn’t have permission to read the Change Log Setup table with his license.
Someone activated and deactivated the Change Log functionality with developer license.
As result there is a blank line in the Change Log Setup table.

Solution:
Open the Change Log Setup table with developer license and remove the blank line.
Otherwise, if you have an installation with Microsoft SQL Server, you can delete this blank line directly running a query in SQL.

Did my solution solve your problem? Leave a reply.

Package Microsoft SQL Server 2005 Express failed with error. See detailed message above.

Package Microsoft SQL Server 2005 Express failed with error. See detailed message above.

The above error message appears when you try to install Microsoft Navision 6 Client on Windows Vista or Windows 7 or Windows 8.

Package Microsoft SQL Server 2005 Express failed with error

Solution:

  1. To copy the contents of DVD to your computer’s hard drive
  2. To explore the content to find \\Prerequisite Components\\Microsoft SQL Server 2005 Express folder
  3. Right-click on the SQLEXPR.EXE file Property -> Compatibility and set the Compatibility Mode to the previous O.S. version
  4. I suggest you to set the Compatibility Mode also for the Autorun.exe file in the main folder.

Did my solution solve your problem? Leave a reply.