Issue with resetting request ID to start at 200000
Trying to reset request ID's to start at 200,000
I used the following query:
insert into workorder(workorderid,requesterid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,isparent,is_catalog_template,fr_duetime,
haschange,hascausedbychange,hasproblem,surveystatus,hasdraft,resolvedtime) values (200000,1,0,0,0,0,0,true,false,0,false,false,false,0,false,0);
Return code:
Msg 128, Level 15, State 1, Line 1
The name "true" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
Build 9105
MSSQL