To create a new service in server 2003 or xp you use the sc.exe tool. REMEMBER TO ADD A SPACE AFTER EVERY EQUAL SIGN!!!! THIS IS VERY IMPORTANT! sc create “my service” binPath= “c:\myfile.exe” type= “own” start= “auto” DisplayName= “my…
I had a need to write a .txt file with build details for every build (windows). This involves using environmental variables and executing a windows batch command. Create c:\buildinfo.bat @echo off echo Build number: %1 echo BUILD_ID: %2 echo JOB_NAME:…
Problem: How can I receive an email when the Redmine admin list changes or a project is changed to publicly viewable? You will need to run some mysql commands / queries in windows batch mode. Solution: Download blat and place…
Need to connect to a windows share from Mac OS X Leopard or Snow Leopard? Here’s how to.. 1. Open Finder 2. Menu “Go” -> “Connect to Server” 3. Type in smb://[ip_of_windows_share]/[sharename] 4. Click “connect” 5. When prompted for authentication…
Howto: check database fragmentation sql server How to find all indexes that have fragmentation over 25%: select * FROM sys.dm_db_index_physical_stats (NULL, NULL, NULL , NULL, ‘LIMITED’) WHERE avg_fragmentation_in_percent > 25.0 AND index_id > 0 AND page_count > 1000 order by…
First off, You CANNOT REVERT this command, so be sure you want to truncate the log! THE QUERY Instructions: Just replace with your DB BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( ”, TRUNCATEONLY)
Howto: Compare two files using freeware or open source Diffmerge is my favorite program (open source at least) that I use to compare files. From their website: DiffMerge is an application to visually compare and merge files for Windows, Mac…
How to clear your flash cache To clear specific sites: When you click on the link, you are taken to the adobe site. On the right hand side of the frame, there is a box that will display a…
Here’s how to send some email in c# using System.Net.Mail; using System.Net.Mime; using System.Net; ///place in a sub-routine or button try { MailMessage mail = new MailMessage(); SmtpClient client = new SmtpClient(“smtp.example.com”); MailMessage message = new MailMessage(“[email protected]”, “[email protected]”); // ,…
restart
