majorsilence

A .NET tool to check file check sums. I wanted an open source GUI tool that would work on Linux and windows that would be able to do this. I did not find any in with five minutes on google so I created my own tool. There is no exception handling (it will crash on errors).

executable
Source Code

Screenshot of it running on Linux.

Sample code for exporting scripts to drop and recreate all user defined Stored Procedures and Functions in a database.

The code uses SQL 2005/2008 Server Management Objects to accomplish this task. It loops through all functions and SPs and writes drop command for each of them then loops through and appends the create scripts for them to the same file. All commands are appended to the "c:\SomePath\SPExport.sql" file.

Update (2010/07/29): Added IronPython example.

C# Code

using Microsoft.VisualBasic;
using System;
using System.Collections;

This is a simple method of history tracking of database changes that in done within in the application. There are other methods to do this including creating triggers within the database itself.

Basically this is one small function that you pass in a dataset and transaction. It loops through each table and each row and column in the table and detects the current state of the row and records it in an audit table.