Recently I was asked if Microsoft Access is actually very powerful. It is! We have created systems that contained more than a million records in some of the tables-
When using PHP, you shouldn’t be using the code to check to see if someone is a admin user or not. That is something you should do with sessions.
What is the difference between queries and tables? (in Microsoft Access for example)
Hypertext Preprocessor (PHP) is a widely used, general-purpose scripting language that was originally designed for Web Development to produce dynamic web pages.
Try the following code:
SELECT D.[name] AS [db_name], D.[rec_model_desc]
FROM sys.databases D LEFT JOIN
MAX(BS.[backup_finish_date]) AS [last_log_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = ‘L’
GROUP BY BS.[db_name]
) BS1 ON D.[name] = BS1.[db_name]
WHERE D.[rec_model_desc] <> ‘SIMPLE’
AND BS1.[last_log_backup_date] IS NULL
ORDER BY D.[name];