Articles under Databases
- Get auto-close and auto-shrink status SQL Server Auto-close and auto-shrink should be FalseBelow is the query to find the options set in your databases. SELECT...
- Rename root in mysql to make it more secure. Information from http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html Step 11: GRANT the...
- MySQL 4.1+ using the old insecure authentication MySQL extension for PHP 5.3 and greater requires that the MySQL server is using a newer and more secure password ...
- SQL 2000 suspect database sp_configure "Allow updates" , 1goupdate sysdatabasesset status = status & ~ 256where (name = 'database ...
- SQL 2000 Single user mode ALTER DATABASE avante_vans SET MULTI_USER WITH ROLLBACK IMMEDIATE
- Unable to connect to MSSQL from PHP Usually the wrong version of ntwdblib.dll is present in PHP folder. Upload version from ...
Cambridge Data Centre
Still need help?
Talk to a UK engineer — we'll help with hosting, servers, billing or migrations with no sales pressure.