Search This Blog

2009-12-14

Start - Run - Utils ( revised )

Control Panel
Windows utility and applications
Disk management
Connection management
Miscellaneous commands

Control Panel



CONTROL MOUSE or MAIN.CPL --- opens mouse properties
CONTROL USERPASSWORDS --- opens User Accounts editor
CONTROL USERPASSWORDS2 or NETPLWIZ --- User account access restrictions
CONTROL PRINTERS --- opens faxes and printers available
CONTROL --- opens the control panel window
CONTROL ADMINTOOLS --- opens the administrative tools
CONTROL KEYBOARD --- opens keyboard properties
CONTROL COLOUR --- opens display properties.Appearance tab
CONTROL FOLDERS --- opens folder options
CONTROL FONTS --- opens font policy management
CONTROL INTERNATIONAL or INTL.CPL --- opens Regional and Language option
APPWIZ.CPL --- opens Add or Remove programs utility tool
OPTIONALFEATURES --- opens Add or Remove Windows component utility
DESK.CPL --- opens display properties. Themes tab
HDWWIZ.CPL --- opens add hardware wizard
IRPROPS.CPL --- infrared utility tool
JOY.CP --- opens game controllers settings
MMSYS.CPL --- opens Sound and Audio device Properties. Volume tab
SYSDM.CPL --- opens System properties
TELEPHON.CPL --- Opens phone and Modem options
TIMEDATE.CPL --- Date and Time properties
WSCUI.CPL --- opens Windows Security Center
ACCESS.CPL --- opens Accessibility Options
WUAUCPL.CPL --- opens Automatic Updates
POWERCFG.CPL --- opens Power Options Properties
AZMAN.MSC --- opens authorisation management utility tool
CERTMGR.MSC --- opens certificate management tool
COMPMGMT.MSC --- opens the Computer management tool
COMEXP.MSC or DCOMCNFG --- opens the Computer Services management tool
DEVMGMT.MSC --- opens Device Manager
EVENTVWR or EVENTVWR.MSC --- opens Event Viewer
FSMGMT.MSC --- opens Shared Folders
NAPCLCFG.MSC --- NAP Client configuration utility tool
SERVICES.MSC --- opens Service manager
TASKSCHD.MSC or CONTROL SCHEDTASKS --- opens Schedule Tasks manager
GPEDIT.MSC --- opens Group Policy utility tool
LUSRMGR.MSC --- opens Local Users and Groups
SECPOL.MSC --- opens local security settings
CIADV.MSC --- opens indexing service
NTMSMGR.MSC --- removable storage manager
NTMSOPRQ.MSC --- removable storage operator requests
WMIMGMT.MSC --- opens (WMI) Window Management Instrumentation
PERFMON or PERFMON.MSC --- opens the Performance monitor
permon -res --on windows 7 opens the performance monitor
MMC --- opens empty Console
MDSCHED --- opens memory diagnostics tools
DXDIAG --- opens DirectX diagnostics tools
ODBCAD32 --- opens ODBC Data source Administrator
REGEDIT or REGEDT32 --- opens Registry Editor
DRWTSN32 --- opens Dr. Watson
VERIFIER --- opens Driver Verifier Manager
CLICONFG --- opens SQL Server Client Network Utility
UTILMAN --- opens Utility Manager
COLORCPL --- opens color management
CREDWIZ --- back up and recovery tool for user passwords
MOBSYNC --- opens Synchronization center
MSCONFIG --- opens System Configuration Utility
SYSEDIT --- opens System Configuration Editor
SYSKEY --- Windows Account Database Security management


Windows utility and applications



EPLORER --- Opens windows Explorer
IEXPLORER --- Opens Internet explorer
WAB --- opens Contacts
CHARMAP --- opens Character Map
WRITE --- opens WordPad
NOTEPAD --- opens Notepad
CALC --- opens Calculator
CLIPBRD --- opens Clipbook Viewer
WINCHAT --- opens Microsoft Chat Interface
SOUNDRECORDER --- opens sound recording tool
DVDPLAY --- run CD or DVD
WMPLAYER --- opens Windows Media Player
MOVIEMK --- Opens untitled Windows Movie Maker
OSK --- opens on-screen Keyboard
MAGNIFY --- opens Magnifier
WINCAL --- opens Calendar
DIALER --- opens phone Dialer
EUDCEDIT --- opens Private Character Editor
NDVOL --- opens the mixer volume
RSTRUI opens Tool System Restore (For Vista only)
% WINDIR% \ SYSTEM32 \ RESTORE \ rstrui.exe opens Tool System Restore (for XP only).
MSINFO32 --- Opens the System Information
MRT --- launches the utility removal of malware.
Taskmgr --- Opens the Windows Task Manager
CMD --- opens a command prompt
MIGWIZ --- Opens the tool for transferring files and settings from Windows (Vista only)
Migwiz.exe --- Opens the tool for transferring files and settings from Windows (for XP only)
SIDEBAR --- Open the Windows (Vista only)
Sigverif --- Opens the tool for verification of signatures of files
Winver opens the window for your Windows version
FSQUIRT --- Bluetooth Transfer Wizard
IExpress opens the wizard for creating self-extracting archives.
MBLCTR --- opens the mobility center (Windows Vista only)
MSRA --- Opens the Windows Remote Assistance
Mstsc --- opens the tool connection Remote Desktop
MSDT --- opens the diagnostic tools and support Microsoft
WERCON --- opens the reporting tool and solutions to problems (for Vista only)
WINDOWSANYTIMEUPGRADE --- Enables the upgrade of Windows Vista
WINWORD opens Word (if installed)
PRINTBRMUI opens migration wizard printer (Vista only)

Disk management

DISKMGMT.MSC --- opens disk management utility
CLEANMGR --- opens disk drive clean up utility
DFRG.MSC --- opens disk defragmenter
CHKDSK --- complete analysis of disk partition
DISKPART --- disk partitioning tool

Connection management


IPCONFIG --- list the configuration of IP addresses on your PC (for more information type IPCONFIG/? in the CMD menu)
INETCPL.CPL --- opens internet properties
FIREWALL.CPL --- opens windows firewall
NETSETUP.CPL --- opens network setup wizard

Miscellaneous

JAVAWS --- View the cover of JAVA software (if installed)
AC3FILTER.CPL --- Opens the properties AC3 Filter (if installed)
FIREFOX --- Mozilla launches Firefox (if installed)
NETPROJ --- allow or not connecting to a network projector (For Vista only)
LOGOFF --- closes the current session
SHUTDOWN -a -f -t 00 --- shut down Windows
SHUTDOWN -a --- the interrupt Windows shutdown
%WINDIR% or% SYSTEMROOT% opens the Windows installation
%PROGRAMFILES% --- Opens the folder where you installed other programs (Program Files)
%USERPROFILE% --- opens the profile of the user currently logged
%HOMEDRIVE% --- opens the browser on the partition or the operating system is installed
%HOMEPATH% --- opens the currently logged user C --- \ Documents and Settings \ [username]
%TEMP% --- opens the temporary folder
VSP1CLN --- deletes the cache for installation of the service pack 1 for Vista
System File Checker (Requires Windows CD if the cache is not available)
* SFC / scannow --- immediately scans all system files and repairs damaged files
* SFC / VERIFYONLY --- scans only those files system
* SFC / Scanfil = "name and file path" --- scans the specified file, and repaired if damaged
* SFC / VERIFYFILE = "name and file path" --- Scans only the file specified
* SFC / scanonce --- scans the system files on the next restart
* SFC / REVERT --- return the initial configuration (For more information, type SFC /? In the command prompt CMD

::START OFFICE APPLICATIONS FROM COMMAND LINE
EXCEL.EXE
FINDER.EXE
INFOPATH.EXE
MSACCESS.EXE
MSPUB.EXE
OIS.EXE
OUTLOOK.EXE
POWERPNT.EXE
WINWORD.EXE

:: OLDIES ( MIGHT HAVE OVERLAPPINGS WITH THOSE ABOVE )



ACCWIZ.EXE - Accessibility Wizard
CALC.EXE - Calculator
CHARMAP.EXE - Character Map
CLEANMGR.EXE - Disk Space Cleanup Manager
CLICONFG.EXE - SQL Client Configuration Utility
CLIPBRD.EXE - Clipbook Viewer
CLSPACK.EXE - Class Package Export Tool
CMD.EXE - Command Line
CMSTP.EXE - Connection Manager Profile Installer
CONTROL.EXE - Control Panel
DCOMCNFG.EXE - Component Services
DDESHARE.EXE - DDE Share
DRWATSON.EXE - Doctor Watson v1.00b
DRWTSN32.EXE - Doctor Watson Settings
DVDPLAY.EXE - DVD Player
DXDIAG.EXE - DirectX Diagnostics
EUDCEDIT.EXE - Private Character Editor
EVENTVWR.EXE - Event Viewer
EXPLORER.EXE - Windows Explorer
FREECELL.EXE - Free Cell
FXSCLNT.EXE - Fax Console
FXSCOVER.EXE - Fax Cover Page Editor
FXSEND.EXE - MS Fax Send Note Utility
IEXPRESS.EXE - IExpress 2.0
LOGOFF.EXE - System Logoff
MAGNIFY.EXE - Microsoft Magnifier
MMC.EXE - Microsoft Management Console
MOBSYNC.EXE - Microsoft Synchronization Manager
MPLAY32.EXE - Windows Media Player version 5.1
MSTSC.EXE - Remote Desktop Connection 127.0.0.1:3388
Remote Desktop Connection
NARRATOR.EXE - Microsoft Narrator
NETSETUP.EXE - Network Setup Wizard
NOTEPAD.EXE - Notepad
NSLOOKUP.EXE - NSLookup Application
NTSD.EXE - Symbolic Debugger for Windows 2000
ODBCAD32.EXE - ODBC Data Source Administrator
OSK.EXE - On Screen Keyboard
OSUNINST.EXE - Windows Uninstall Utility
PACKAGER.EXE - Object Packager
PERFMON.EXE - Performance Monitor
PROGMAN.EXE - Program Manager
RASPHONE.EXE - Remote Access Phonebook
REGEDIT.EXE - Registry Editor
REGEDT32.EXE - Registry Editor
RESET.EXE - Resets Session
RSTRUI.EXE - System Restore
RTCSHARE.EXE - RTC Application Sharing
SFC.EXE - System File Checker
SHRPUBW.EXE - Create Shared Folder
SHUTDOWN.EXE - System Shutdown
SIGVERIF.EXE - File Signature Verification
SNDREC32.EXE - Sound Recorder
SNDVOL32.EXE - Sound Volume
DIALER.EXE - Phone Dialer
HELPCTR.EXE - Help and Support

Control Panel Tools

ACCESS.CPL - Accessibility Options
APPWIZ.CPL - Add or Remove Programs
DESK.CPL - Display Properties
HDWWIZ.CPL - Add Hardware Wizard
INETCPL.CPL - Internet Explorer Properties
INTL.CPL - Regional and Language Options
JOY.CPL - Game Controllers
MAIN.CPL - Mouse Properties
MMSYS.CPL - Sounds and Audio Device Properties
NCPA.CPL - Network Connections
NUSRMGR.CPL - User Accounts
ODBCCP32.CPL - ODBC Data Source Administrator

POWERCFG.CPL - Power Options Properties
SYSDM.CPL - System Properties
TELEPHON.CPL - Phone and Modem Options
TIMEDATE.CPL - Date and Time Properties

Microsoft Management Console (MMC Snap-ins)
:: - Certificates
CERTMGR.MSC
CIADV.MSC - Indexing Service
:: COMPUTER MANAGEMENT
COMPMGMT.MSC
:: - DEVICE MANAGER
DEVMGMT.MSC
:: DISK DEFRAGMENTER
DFRG.MSC -
:: - Disk Management
DISKMGMT.MSC
:: Event Viewer
EVENTVWR.MSC

FSMGMT.MSC - Shared Folders
:: Local Users and Groups
LUSRMGR.MSC
:: REMOVABLE STORAGE
NTMSMGR.MSC
:: REMOVABLE STORAGE OPERATOR REQUESTS
NTMSOPRQ.MSC
:: PERFORMANCE MONITOR
PERFMON.MSC
:: SERVICES
SERVICES.MSC
:: WINDOWS MANAGEMENT INFRASTRUCTURE
WMIMGMT.MSC

:: CONVENTIONAL USER ACCOUNT INTERFACE
CONTROL USERPASSWORDS2 -
:: KEYBOARD PROPERTIES
control keyboard

2009-12-01

The meta columns view



USE [Gaf]
GO
 
/****** Object:  View [dbo].[viewMeta_TableColumns]    Script Date: 12/01/2009 08:11:48 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[viewMeta_TableColumns]'))
DROP VIEW [dbo].[viewMeta_TableColumns]
GO
 
USE [Gaf]
GO
 
/****** Object:  View [dbo].[viewMeta_TableColumns]    
Script Date: 12/01/2009 08:11:48 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
CREATE VIEW [dbo].[viewMeta_TableColumns]  
AS   
 
 
-- Action !!!
SELECT top 100000
SO.NAME AS 'TableName', 
SC.NAME AS 'ColumnName', 
st.name as 'DataType' , 
sc.is_nullable as 'IsNullable' ,
sc.is_identity as 'IsPrimaryKey' ,  
sc.max_length AS 'MaxLength' , 
SC.is_computed as 'IsComputed' , 
sm.text as 'DefaultValue'
FROM dbo.sysobjects SO 
INNER JOIN sys.all_columns SC ON SO.id = SC.object_id
INNER JOIN sys.types st on st.system_type_id = sc.system_type_id
LEFT JOIN syscomments sm on SO.id = sm.id
--LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id  
--inner join sys.types st
--on sc.xtype = st.system_type_id
WHERE SO.xtype = 'U'  
--and SO.name = @TableName --uncomment this line while debugging
ORDER BY SO.[name],  SC.object_id
 
 
GO
 
/* 
select * from viewMeta_TableColumns
 
*/

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) git cheat sheet (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smtp (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List

VideoBar

This content is not yet available over encrypted connections.