SQL Script

GDPR, NAV Data discovering from SQL Server, Part I

by

GDPR, NAV Data discovering from SQL Server, Part I Hi people, The GDPR deadline is approaching! …for users who use older versions of NAV (and who do not want to upgrade NAV or purchase third-party tools) it may be useful to have useful functions to search for data (in NAV SQL Server Database). Having a … Read more

NAV 2013 SQL Query Codeunit Tool (SQL From NAV Part II)

by

NAV 2013 SQL Query Codeunit tool i found this nice demo tool by Dynamic Manufacturing Solutions on Mibuso. Source http://mibuso.com/downloads/nav-2013-sql-query-codeunit nice tool, based on .NET integration (AD), usefull if you don’t like Powershell. Purpose of this tool “Simple codeunit allows you to execute an SQL query to populate any NAV (temporary) table using one call.  … Read more

“HOW TO RESET” NAV “BAD” USER

by

  “HOW TO RESET” NAV “BAD” USER If you have some issues with NAV single user (ex; can’t login, permissions lost, errors on pages etc.), you can delete ALL user configuration and after recreate a new user. Follow procedure below. use DB GO 1) FIRST: SELECT [User Security ID] from USERNAME retrieve User Security ID … Read more

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure

by

sp_whopro™ – SQL Server Activity Monitoring and Logging Stored Procedure Great SQL Script ! Source: SQLDownload Download Post Views: 1,366

SQL Sessions Killer 2.0

by

SQL Sessions Killer 2.0 If you have some issues about “there are no more NAV license availables.. you can’t login” and issues seem caused by multiple sessions consumed by NAS and NAV Users (user with multilple logins not closed etc..), you can create and schedule these SQL stored procedure to kill inactive NAS & Inactive Users … Read more

Automate backup on SQL Express and Send Mail Powershell Script

by

Sql Server Backup Automation and send-email Solution to automate backup on SQL Express and send mail based on first Microsoft SQL BackupScript “sp_SQLBackupDatabases” Scheduling NB: SQL Server Agent “is not available” on this SQL release You can schedule jobs with standard “Windows Jobs“ ! How System Works: 3 Objectsd based procedure: 1) batch file > … Read more

%d bloggers like this: