From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Which SQL script to use for setting up default TestStand tables?

Solved!
Go to solution

Hello,

 

I'm creating a small test application and would like to log test results to an SQL Server database. The Preparing to Implement Database Logging page mentions scripts that I can use to set up my database. In my folder, I found 3 table creation scripts:

  • SQL Server Create Generic Insert Result Tables.sql
  • SQL Server Create Generic Recordset Result Tables.sql
  • SQL Server Create Stored Proc Result Tables.sql

What are the differences between these, and which should I use?

 

 

Thanks!

Certified LabVIEW Developer
0 Kudos
Message 1 of 2
(3,677 Views)
Solution
Accepted by JKSH

In the database options dialog --> Go to the schemas tab and click on each one of the options ( generic recordset,Generic INsert,etc).In the comments section you will find the difference.

 

You can use either of them but ensure that the whatever tables script you have run on the DB same option is selected in the DB options.

Hope this helps.

 

Message 2 of 2
(3,671 Views)