We just run into an interesting problem where starting the SQL Server Agent would start and then immediately stop. No errors were reported in the event log, but running the following via the command line returned “StartServiceCtrlDispatcher failed (error 6)“ “[[your SQL Path]]BinnSQLAGENT.EXE” -i [[sql Instance]] Googling the error in question returned this forum post…
As part of my current project, I’ve spent some time over the past couple of months trying to determine the best (cheapest) SQL Server configuration to support web servers running in a virtualised environment. As a quick disclaimer, the following are my thoughts on the subject and should be used as guidance for further research…
The following SQL contains a subtle bug that will always result in the text “No Rows Affected” being output. [code language=”sql”] SELECT ‘Hard Coded Row’ IF(@@ERROR <> 0) Print ‘Error Occured’ ELSE IF(@@ROWCOUNT = 0) Print ‘No Rows Affected’ [/code] The error occurs because the reference to @@ERROR in the first “IF” statement counts as…
Over the weekend I went along to the fantastic DeveloperDeveloperDeveloper day held at Microsoft up in Reading. The quality of the presentations was fantastic and even for frameworks/subjects I was familiar with I learnt loads. For me, the most useful presentation came at the end of the day (just as the brain was beginning to…