HOW TO detect status of a service & manipulate it programmatically

This KB article which explains how to detect status of SQL Server Express service & start it programmatically, can also be used to detect any other service by replacing the appropriate service name.

The System.ServiceProcess.ServiceController class is used to detect the status of a service and start it if required.

Comments

Post a Comment

Popular posts from this blog

HOW TO Read Linux ext4 Files on Windows with 7-Zip (No Drivers Needed)

Image
File systems are the organizational systems that decide how data is stored, named, located, and protected on a disk, SSD, USB drive, or partition. They handle directories, file metadata (permissions, timestamps, ownership), free space tracking, and more. Windows side Windows primarily uses: NTFS — the modern default. It supports journaling (for crash recovery), large files and volumes, fine-grained permissions, encryption, and compression. FAT32 and exFAT — simpler, widely used on removable media (USB sticks, SD cards) because they are highly cross-compatible with other operating systems. Windows has no native support for the main Linux file systems. When you connect a drive formatted with ext2/3/4, Windows typically sees it as “RAW” or unknown and may offer to format it (which would destroy the data). Linux side Most Linux distributions default to the ext family: ext2 — the older, non-journaling version. ext3 — added journaling for better reliability. ext4 — the current standard. It a...
Read more

20 SQL Server 2005 Keyboard Shortcuts

What is the bored mother of a geek called? Motherboard There are a bunch of SQL Server 2005 Keyboard Shortcuts on MSDN , but I find these 20 super convenient & use it very often. Description Shortcut Create a New File CTRL+N Toggle full screen mode SHIFT+ALT+ENTER Set or remove a bookmark at the current line CTRL+K, CTRL+K Next bookmark CTRL+K, CTRL+N Previous bookmark CTRL+K, CTRL+P Clear bookmarks CTRL+K, CTRL+L Make the selected text a comment CTRL+K, CTRL+C Uncomment the selected text CTRL+K, CTRL + U Make the selected text upper case CTRL+SHIFT+U Make the selected text lower case CTRL+SHIFT+L Toggle between query and results pane F6 Display Object Explorer F8 Output results in text format CTRL+D Output results in a grid CTRL+T Cancel the executing query ALT+BREAK Display the estimated execution plan CTRL+L Display the Replace dialog box CTRL+F Display the Find dialog box CTRL+H Start incremental search CTRL+I Find the next occurrence of the previous search text F3 Related link...
Read more

The Diet Delinquent

Image
See more of my AI co-creations With just a prompt, Grok was able to take a  repurposed   hand-drawn cartoon from 2004  and generate an image of it doing a 'namaste'.  I’ve been getting by with free Windows-native tools like Paint, Paint 3D , and the Generative Erase feature in Photos . Grok's image editing feature, which can be activated simply by prompting, is a fantastic resource for amateur cartoonists. 
Read more