Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in. June 2009 Entries
Check & Kill Process
private void CheckExcellProcesses()Proce... AllProcesses = Process.GetProcessesByName(... Hashtable();int iCount = 0;foreach (Process ExcelProcess in AllProcesses)private void KillExcel()Process[] AllProcesses = Process.GetProcessesByName(... check to kill the right process { ExcelProcess.Kill(); } AllProcesses = } foreach (Process ExcelProcess in AllProcesses)if (myHashtable.ContainsKey(Ex... == false)null; { myHashtable = { myHashtable.Add(ExcelProces... iCount); ......

Posted On Monday, June 29, 2009 5:36 AM

Truncating All Tables
Create Procedure GT_DeleteRecords_AllTables As /**************************... Stored Procedure: GT_DeleteRecords_AllTables Do not excute this proc Purpose: Delete ALL records within ALL the tables in a DB with ease. Test: Exec GT_DeleteRecords_AllTables*... Set Exec nocount on sp_MSForEachTable 'Alter Table ? NoCheck Constraint All' Exec sp_MSForEachTable ' If ObjectProperty(Object_ID(''... ''TableHasForeignRef'')=1 ......

Posted On Monday, June 29, 2009 5:21 AM

Copyright © Gaurav Taneja | Powered by: