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.

This message occurred because a nonzero value was found

—————————
Microsoft Dynamics NAV Development Environment
—————————
You cannot delete or change the type of the {FieldName} field (in the {TableName} table) before the value in the field is reduced to 0 (zero) or ” (blank) in all records. This message occurred because a nonzero value was found for the record {PKFieldName}='{PKFieldValue}’ in company {CompanyName}.
—————————
OK
—————————

This message occurred because a nonzero value was found

Cause:
To change the definition of a field this doesn’t have to contain data.

Solution:
Delete all the values in the {FieldName} column (of the {TableName} table) for all the companies.
Note: the error message will show the first value the system will find, remember that you have to delete values also in the other companies.

HOW TO change data for all Companies?

If you want you can create a new field as a copy, create a Report for service to move data in the new field before to delete all the data and change the definition of the field. Then you could restore the original data in the original field.

Did my solution solve your problem? Leave a reply.