PowerShell Script to Update MS Access (.MBD) Database The Contents of the .Reg File are as below:
Script connects to the .MDB file using user DSN named “MS Access Database” pointing to the .MDB file and then queries the specified columns. .
SQL Script to list all DBs Sizes in MBs
Create below SearchSQLDB Stored Procedure by connecting to the target SQL DB in your SQL MGMT studio. Then run the stored procedure as shown below: .
Its possible that an AWS instance can run into various issues of unexpected crashes or can even be a case where you lost connectivity to your instance possibly due to network/firewall issue at AWS level or within your instance. In either of these cases, you’d have no choice than to re-configure your solution on a […]