For backing up old files I tend to sort into lots of different folders, anything I am finished with I put in a 7zip Archive The following batch makes use of a For loop in the batch, uses 7-zip with Ultra Compression and names the archive the same as the folder.
1 2 | for /D %%X in (*) do "c:\Program Files\7-Zip\7z.exe" a -mx9 "%%X.7z" "%%X\" pause |
Credits: SS64
We have an issue where on a rare occasion a scan from V1 DBScanner to DBCapture can corrupt the queue and cause DBCapture Admin to state it is unable to open a document rendering the whole application unusable. I have a batch script to perform some maintenance. Over time I have commented out lines which […]
I had an issue where a server which was joined to a domain had incorrectly set its network as Public. A TechNet article and TenForum article provided the answer (As it states Windows 10 it also applies to Server 2012) so I have placed credits above the steps I followed. Following a re-occurrence I have […]
The Event Viewer from Server 2008 onwards is XML based. Filters based on XML syntax can be used such as:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | <QueryList> <Query Id="0" Path="System"> <Select Path="System"> *[EventData[Data and (Data='<Search Parameter>')]] </Select> </Query> </QueryList> <QueryList> <Query Id="0" Path="Application"> <Select Path="Application"> *[EventData[Data and (Data='<Search Parameter>')]] </Select> </Query> </QueryList> |
You can search for anything which appears in the data section such as service names, error messages etc..
1 2 3 4 5 6 7 | - <EventData> <Data Name="param1">Service Display Name</Data> <Data Name="param2">Details</Data> <Data Name="param3">Details</Data> <Data Name="param4">Service Name</Data> </EventData> </Event> |
Notes: MS Technet
Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500 and Datalinx WHM (Although its easy enough to change, the first “set @SSCC” basically gets the digits, the rest of the code simply calculates the check digit). This proc uses the Datalinx WHM Pallet ID […]
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do this even with users off I was being shown errors stating it must be done in Single User Mode. I decided I wanted to do this as quickly as possible so slapped together some SQL […]
I had a user unable to use a script which generated an email, I found the user didn’t have permission, Microsoft state: To reduce the surface area of SQL Server, Database Mail stored procedures are disabled by default. To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb […]
A while ago we added error trapping to the batch file called by a SQL script, this was to ensure if a program failed the rest of the process would not run: After ensuring the program would return an error level if something went wrong we then I then used the ErrorLevel and an if […]
Credits (As what I consider the hard stuff was actually done by other people): TheSmileyCoder for the solid awesome little VBS File, this basically gets around the limitation of not actually getting Access to load another Access Database. At the time I only ever needed one modification (A rarely issue affected two P4 machines with […]
Nearly every single Microsoft Access “database” I use has a proper database attached instead of using the internal Jet Engine, this means data is not actually stored in the Access “database” and I therefore call them Access Frontends. Compiling your Access front ends to ACCDE provides a compiled copy of your Access Front End. I […]