Monthly Archives: January 2015

MySQL Startup error

Installed an windows version of MySQL and was trying to start it from a cmd prompt. To Start MySQL server from command line, you should start a console window (or “DOS window”) and enter the below or direct your command to … Continue reading

Posted in Administration, MySQL | Leave a comment

User and User Group Queries

I get user requests all the time for access rights and i don’t have read access to AD to check groups to see if the user is already a member or not. We can run the below scripts from SQL server Management … Continue reading

Posted in MSSQL, Permissions | Leave a comment

Consistency Errors due to MSG 8914 – PFS free space

Issue While running DBCC CHECKDB() job on SQL 2008 R2 SP1 with SQL 2005 compatibility Level databases, it failed with the below DBCC results for ‘MESTEMPLATEDOCUMENTS’. Msg 8914, Level 16, State 1, Line 1 Incorrect PFS free space information for … Continue reading

Posted in Database Corruption, MSSQL | Leave a comment