Find processes which have been using tempdb
Credit: Microsoft TechNet On some occasions a few MS SQL databases have exhausted tempdb space, this was due to users […]
Sage Line 500 EDI IN Intermediary tables inner join on sql query
On ocassion I need to look at what is in the EDI IN modules intermediary tables, scheme.eiordtm has an annoying […]
Display advanced properties of scheduled tasks in command line
The following command requests a detailed display of the tasks on the local computer. It uses the /v parameter to […]
A simple batch file which compresses every folder into a 7z Archive
For backing up old files I tend to sort into lots of different folders, anything I am finished with I […]
Rebuild a V1 DBCapture Database Queue
We have an issue where on a rare occasion a scan from V1 DBScanner to DBCapture can corrupt the queue […]
Updating a network location in Windows 2012
I had an issue where a server which was joined to a domain had incorrectly set its network as Public. […]
Filtering in Event Viewer Windows Server 2008 onwards
The Event Viewer from Server 2008 onwards is XML based. Filters based on XML syntax can be used such as: […]
Method of working out check digit for an SSCC code
Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500 […]
Apply ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to SQL Server
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do […]
Add a user to DatabaseMailUserRole on msdb
I had a user unable to use a script which generated an email, I found the user didn’t have permission, […]