DOS Batch file To search string in given file

 

Requirement:

To Search the given files under current directory for given strings. If anything found to be written to a file.

Sample Screen:

 

Main Script: CHK_Error.bat

@echo off set fname= set filename= set yyyymmdd= set hhmm= IF %1. NEQ . (set fname="C:\Accounts\CalWIN\Build\SQLServer\DOS_Batch\%1*.lst") ELSE ( GOTO _Usage ) for /F "tokens=2-4 delims=/ " %%i in ('date /t') do set yyyymmdd=%%k%%i%%j for /F "tokens=1-2 delims=: " %%l in ('time /t') do set hhmm=%%l%%m set filename=Error_%yyyymmdd%%hhmm%.txt echo "Error Log file name is : " %filename% echo "files to be searched : " %fname% findstr /i /n /g:search.txt  %fname% > %filename% if %errorlevel% == 0 (GOTO :_Error_Found ) else  ( Echo  **  No Errors found    ** Goto :END ) :_Error_Found notepad %filename% Goto :END :_Usage echo " Usage is chkerrors.bat <filestring> :END @echo on

Search.txt

msg error severity warning fail fatal

Input Files: file1.lst

dgadagdagad abacdefghijklmnopqrstuvwxyzagadgda gagad st messgae g adgadg agadgadgadadadsflmsvbkobsagad dgadg ad ddad dgadgadg error 121 dgad gdagad gadagad gagad msg 128, 9341353513

Input Files: file2.lst

test messgae g sagad dgadg ad ddad dgadgadg error 121 dgad gdagad gadagad gagad msg 128, 9341353513

ZoomIt screen zoom and annotation tool for presentation

 

ZoomIt is screen zoom and annotation tool for technical presentations that include application demonstrations. ZoomIt runs unobtrusively in the tray and activates with customizable hotkeys to zoom in on an area of the screen, move around while zoomed, and draw on the zoomed image.

Enjoy using this tool on your presentation. It can be downloaded from http://technet.microsoft.com/en-us/sysinternals/bb897434

SQL Server Management Studio – SSMS is a 32 bit application

SQL Server Management Studio – SSMS is a 32 bit application. Even when we install 64 bit SQL Server Database Engine, we will get 32 bit SSMS installed on the server.

Default SSMS install location

32 Bit Server	C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
64 Bit Server	C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

TSM TDPSQL Backup failed

 

Recently when i tried TSM TDPSQL backup with the new server on SQL Server 2008 failed with the error below.

“ TSM TDP SQL Error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Process Exit Code 1914. The step failed. “

Resolution:
After investigation, installed the TSM TDP SQL version 5.5.4.0 from 5.5.0. This resolved the issue.

Software Asset Management - SAM

Software Inventory Assistance

Whether we have just a few computers or a large network, a software inventory tool can make it easier to quickly know what we have and how it's being used.

The Microsoft Software Inventory Analyzer (MSIA) is a free tool available for download that can help us with our software inventory. It is built specifically to be a starting point to working with SAM.

We can use the MSIA to scan and inventory the Microsoft software that is installed on a single computer, or on multiple computers throughout a network. It generates a report that provides details of all installed Microsoft products, including the type and the number of licenses. The MSIA will work with networks that have 250 or fewer computers. The latest MSIA 5.1 features enable you to:

• Identify and report all installed Microsoft products listed under Add or Remove Programs.
  
• Consolidate the MSIA report with the Microsoft Licensing Statement (MLS) report (.xls only).
  

This information is useful for you, if you are taking care of the system administration, licensing and inventory of Microsoft software products in your organization.

Free SQL Server tools that might make your life a little easier

check out on below link for free SQL Server tools that might make your life a little easier
http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/free-sql-server-tools-that-might-make-your-life-a.aspx