Skip to main content

Database Toolset

Toolset of tools and script for maintaining the databases. We also included scripts for different applications. 

Copyright Notice

SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of SFL Services LLC, who reserve the right to change specifications and other information contained herein without prior notice. The reader should consult SFL Services LLC to determine whether any such changes have been made.

Licensing and Warranty

The terms and conditions governing the licensing of SFL Services LLC software consist solely of those set forth in the written contracts between SFL Services LLC and its customers. Except as expressly provided for in the warranty provisions of those written contracts, no representation or other affirmation of fact contained in this document, including but not limited to statements regarding capacity, suitability for use or performance of products described herein, shall be deemed to be a warranty by SFL Services LLC for any purpose, or give rise to any liability of SFL Services LLC whatsoever.

Liability

In no event shall SFL Services LLC be liable for any incidental, indirect, special or consequential damages whatsoever (including but not limited to lost profits) arising out of or related to this document or the information contained in it, even if SFL Services LLC had been advised, knew or should have known of the possibility of such damages, and even if they had acted negligently.

ESP - Delete Old Messages

/* This will delete all old XML messages and events older then 5 days SFL 2008-11-29 Crea...

ESP - Database Copy Script

/* Search and replace for the ESP database and its folders Created By : SFL 08/13/23 Modifie...

ESP - Delete User

/* Delete users from ESP which do not exist in Active Directory Created By : Steve Ling 2024/...

ESP - Create Financial Year and Period

/* Script to auto add finacial year and its periods if they are missing Created By : Steve Ling...

MsSQL - Create Database Table from Code

declare @TableName sysname = 'TableName' declare @Result varchar(max) = 'public class ' + @Table...

ESP - Add Notifications to All Active Companies

/* This script will add Notifications to all active companies Please run in SQLAgent every 15 m...

ESP - Delete Product Design in Imported Status

/************************************************ This script is to delete PD that do not have ...

ESP - Delete Old Message

/* This will delete all old XML messages and events older then 5 days SFL 2008-11-29 Crea...

SQL - Kill Database Connections

/* This is to kill off any connection to a database Created by : Steve Ling 2022/03/20 *...

MsSQL - Backups

Introduction This is to create auto backups on a SQL server and place them on a drive. Credits ...

MsSQL - Verify Properties

/* This will check the proprties on a given Database and also the server Created By : Steve...

MySQL - Bag Of Tricks

Introduction This document has many useful command. MySql Kill users You can use the following...

MsSQL - SQL Reporting Services

Enable Errors Connect to the database engine in SSMS and navigate to the ReportServer databa...

MsSQL - Move TempDB To Another Drive

Sometimes as a database administrator, you need to move the TempDB database and log files to a ne...

MsSQL - Set All User Tables to Simple on DEV/TEST Server

/* This script is to set all of the user database to simple on a DEV/TEST server Use the @U...