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 existSolution: Change the service to logon on as system account … [Read more...] about SQL Server Express Error 17053
SQL
Using Select into in Sql server
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 this in SQL 2005. … [Read more...] about Using Select into in Sql server
