Table of Contents
Ispirer Website
Ispirer Assessment Tools Overview
Free Trial
Native Tools
After installing the “Microsoft SQL Server”, run “SQL Server Enterprise Manager” in version before 2000 year or “SQL Server Management Studio” in version after 2005 year in and configure a connection to your database server.
Volume of Data
Before 2000 year
In order to know the Database size, select the database and click on the right mouse button, select “Properties” in “SQL Server Enterprise Manager”:
Click the tab “General”. To see the size data in database need to subtract the value of “Space available” from the value of “Size”. Result of the expression “Size - Space available ≈ Size data in database” and will be the approximate size of the database.
After 2005 year
In order to know the Database size, select the database and click on the right mouse button, select “Properties” in “SQL Server Management Studio”:
Click the tab “General”. To see the size data in database need to subtract the value of “Space available” from the value of “Size”. Result of the expression “Size - Space available ≈ Size data in database” and will be the approximate size of the database.
Number of Lines of Code (LOC)
Before 2000 year
In order to know the number of lines of codes in the objects database, select the database and click on the right mouse button, select “All Tasks” → “Generate SQL Script”:
On the tab “Formatting” must select only “Generate the CREATE <object> command for each object” for correct calculation of lines of code:
Without Triggers
For generating a sql script without triggers, must on the tab “Options” remove all the flags, as well as in “File to Generate” must install flag for “Greate one file”, that select all objects in one files with coding “International text (Unicode)”, which must be installed in “File Options” → “File Format”.
With Triggers
For generating sql script with triggers, must on the tab “Оptions” in “Table Scripting Options” install flag for “Script triggers”, as well as in “File to Generate” must install flag for “Greate one file”, that select all objects in one files with coding “International text (Unicode)”, which must be installed in “File Options” → “File Format”.
For generating sql script with triggers, as well as must install flag for “All tables” on the tab “General” in “Objects to script”, in advance clicking on the button “Show All”.
After 2005 year
In order to know the number of lines of codes in the objects database, select the database and click on the right mouse button, select “Tasks” → “Generate Scripts”:
