Dear Microsoft I Occasional get the Msg 213 Error Message.
I Under stand what the error means. and How to fix it, but what I do not understand is how my SQL Script can run some times without issues, and then othertimes with this error message.
The last couple of times I have rebooted my Computer and the message does not occur again (without making any alterations to the SQL Script).
I suspect it has something to do with the locking of the file using the Microsoft Skydrive App.
It Occurs over two Scripts
CREATE TABLE REGION (
REGION_ID INT NOT NULL UNIQUE IDENTITY,
REGION_NAME VARCHAR(2) NOT NULL,
REGION_DESC VARCHAR(20) NOT NULL,
PRIMARY KEY (REGION_ID) );
INSERT INTO REGION VALUES ('NW', 'North West'),('SW', 'South West'),('MN', 'Mid North'),('MS', 'Mid South'),('NE', 'North East'),('SE', 'South East');