Have not used express for a while and when I when to start the service I got an 17053 error saying could not open master.mdf, etc even though the files exist Solution: Change the service to logon on as system […]
It’s a No NoDon’t use select into as it locks the tempdb for the duration of the select. You have to create the temp table fist and then do a insert … select … from. Need to look at it […]