To generate Platform specific assembly such as X86 machine running 32 bit Windows Verson, X64 machines running 64-bit windows, Itanium or ancpu(default). The resulted code can run on the target platform. use /platform:string option of the csc compiler.

While designing a windows service if you are planning to use a timer control, make sure not use the System.Windows.Forms.Timer. The timer event will not tick. You have to use the System.Timers.Timer , which will work properly. I came to know about this a

Here is the way to disbale/enable the SQL Jobs or its schedule from remote computer, The script is usning windows authentication and querying the MSDB database. [code] --Main Scripts SQLCMD.EXE -S <servername> -E -dmsdb -h-1 -iQueryToRun_MSDB.s

You can check the status of a SQL job and log the customised success or failure message of the job for the day in the Windows Event Viewer. [code] IF NOT EXISTS (SELECT TOP 1 run_date FROM msdb.dbo.sysjobhistory WHERE job_id=(SELECT job_id FROM m

To identify running jobs in a remote server we can use sp_help_job command in the following way. [code] --Content of sqlQuery.sql exec msdb.dbo.sp_help_job @execution_status = 0 --Main Code to execute. sqlcmd.exe -S<servername> -U<username&g

http://vb-net.ru/, this website has nice articles and help for .NET and sql server related stuff. The only thing you have to do is open this in google chrome and say translate to ENGLISH. Also you can select a language at the right hand side drop down.

Install the Tweet Button for Chrome. Fast & simple way to share the currently viewed page on Twitter. Also displays the official Tweet Count for every web page.