Build sql TestStand Database option dialog

[Cluo]

why I can't execute the sql file successfully which generated on the Schemas tab of Database option dialog in TestStand?

[Rodéric]

Hi,

I had the same problem, you have to modify the file, as I remember I had the ~ removed and it worked!

[Cluo]

Hi, Even though I delete the ~, it does not work. (I execute that in sql server 2005 express) the result is : Msg 102, Level 15, State 1, Line 9 Incorrect syntax near ','. Msg 102, Level 15, State 1, Line 23 Incorrect syntax near ','. Msg 137, Level 15, State 2, Line 37 Must declare the scalar variable "@pEXECUTION_TIME". Msg 102, Level 15, State 1, Line 57 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 68 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 94 Must declare the scalar variable "@pUUT_RESULT". Msg 102, Level 15, State 1, Line 121 Incorrect syntax near '('. Msg 134, Level 15, State 1, Line 124 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 132 Must declare the scalar variable "@pSTEP_RESULT". Msg 102, Level 15, State 1, Line 147 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 151 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 166 Must declare the scalar variable "@pSTEP_RESULT". Msg 102, Level 15, State 1, Line 181 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 188 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 199 Must declare the scalar variable "@pPROP_RESULT". Msg 102, Level 15, State 1, Line 218 Incorrect syntax near '('. Msg 134, Level 15, State 1, Line 222 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 237 Must declare the scalar variable "@pSTEP_RESULT". Msg 102, Level 15, State 1, Line 252 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 259 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 270 Must declare the scalar variable "@pPROP_RESULT". Msg 102, Level 15, State 1, Line 289 Incorrect syntax near '('. Msg 134, Level 15, State 1, Line 292 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 307 Must declare the scalar variable "@pSTEP_RESULT". Msg 102, Level 15, State 1, Line 322 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 333 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 348 Must declare the scalar variable "@pPROP_RESULT". Msg 102, Level 15, State 1, Line 363 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 372 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 385 Must declare the scalar variable "@pPROP_RESULT". Msg 102, Level 15, State 1, Line 397 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 407 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 420 Must declare the scalar variable "@pPROP_RESULT". Msg 102, Level 15, State 1, Line 432 Incorrect syntax near ','. Msg 134, Level 15, State 1, Line 442 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 455 Must declare the scalar variable "@pPROP_RESULT". Msg 102, Level 15, State 1, Line 471 Incorrect syntax near '('. Msg 134, Level 15, State 1, Line 474 The variable name '@pID' has already been declared. Variable names must be unique within a query batch or stored procedure. Msg 137, Level 15, State 2, Line 484 Must declare the scalar variable "@pPROP_RESULT".