esper Quote:Когда запускаю скрипт trading.sql - вылазят ошибки
Какие именно ошибки?
вот чего пишет
Msg 15025, Level 16, State 1, Line 41
The server principal 'trading' already exists.
Msg 1801, Level 16, State 3, Line 3
Database 'Trading' already exists.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '100'.
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 102, Level 15, State 6, Line 2
Incorrect syntax near 'HONOR_BROKER_PRIORITY'.
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 2
Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)".
File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 2
Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 3446, Level 16, State 2, Line 2
Primary log file is not available for database 'Trading'. The log cannot be backed up.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 945, Level 14, State 2, Line 2
Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 15023, Level 16, State 1, Line 3
User, group, or role 'trading' already exists in the current database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Exchange' in the database.
Msg 6246, Level 16, State 1, Line 2
Assembly "Ecng.Data.SqlServer" already exists in database "master".
Msg 6249, Level 16, State 1, Line 1
The associated file "Ecng.Data.SqlServer.pdb" already exists for assembly "Ecng.Data.SqlServer".
Msg 6249, Level 16, State 1, Line 1
The associated file "Properties\AssemblyInfo.cs" already exists for assembly "Ecng.Data.SqlServer".
Msg 6249, Level 16, State 1, Line 1
The associated file "SqlExtendedProcedures.cs" already exists for assembly "Ecng.Data.SqlServer".
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'AutoDeployed' already exists for 'Ecng.Data.SqlServer'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'Ecng.Data.SqlServer'.
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #3: Cannot find data type time.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'HistorySession' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Strategy' in the database.
Msg 2714, Level 16, State 3, Procedure usp_RethrowError, Line 26
There is already an object named 'usp_RethrowError' in the database.
Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #24: Cannot find data type datetime2.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Portfolio' in the database.
Msg 2714, Level 16, State 51, Procedure PageSelect, Line 2
There is already an object named 'PageSelect' in the database.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'AutoDeployed' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'SqlAssemblyFile' already exists for 'dbo.PageSelect'.
Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38
Property cannot be added. Property 'SqlAssemblyFileLine' already exists for 'dbo.PageSelect'.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #3: Cannot find data type time.
Parameter or variable '@WorkingFrom' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #4: Cannot find data type time.
Parameter or variable '@WorkingTo' has an invalid data type.
Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1
Column, parameter, or variable #5: Cannot find data type time.
Parameter or variable '@Interval' has an invalid data type.
Msg 2714, Level 16, State 3, Procedure MarketDataSourceSettings_ReadBySourceId, Line 4
There is already an object named 'MarketDataSourceSettings_ReadBySourceId' in the database.
Msg 2714, Level 16, State 3, Procedure HistorySession_Count, Line 3
There is already an object named 'HistorySession_Count' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_Count, Line 3
There is already an object named 'Exchange_Count' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_UpdateByName, Line 18
There is already an object named 'Exchange_UpdateByName' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_ReadByName, Line 4
There is already an object named 'Exchange_ReadByName' in the database.
Msg 2714, Level 16, State 3, Procedure Exchange_ReadAll, Line 6
There is already an object named 'Exchange_ReadAll' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'HydraSecurityInfo' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Order' in the database.
Msg 2714, Level 16, State 3, Procedure HistorySession_ReadAll, Line 6
There is already an object named 'HistorySession_ReadAll' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Position' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Trade' in the database.
Msg 2714, Level 16, State 3, Procedure Security_ReadAll, Line 6
There is already an object named 'Security_ReadAll' in the database.
Msg 2714, Level 16, State 3, Procedure Security_Count, Line 3
There is already an object named 'Security_Count' in the database.
Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1
Column, parameter, or variable #24: Cannot find data type datetime2.
Parameter or variable '@LastTradeTime' has an invalid data type.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'OrderFail' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'MyTrade' in the database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'HistorySessionOrder' in the database.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_HistorySessionOrder_Order' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_HistorySessionOrder_Session' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_HydraSecurityInfo_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_MyTrade_Order' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_MyTrade_Trade' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Order_Portfolio' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Order_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_OrderFail_Order' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Portfolio_Exchange' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Position_Portfolio' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Position_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.Security" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Security" because it does not exist or you do not have permissions.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_Trade_Security' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
и в папке c:\stocksharp\ пусто
как и где сделать "Run the RECONFIGURE statement to install." не могу никак вдуплить. SQL пока для меня совсем никак...