Monthly Archives: May 2008

The magic of EXEC msdb.dbo.sp_send_dbmail

Configure under the "management" folder of SQLServer. Advertisements

Posted in Uncategorized | Leave a comment

WCF tracing

http://msdn.microsoft.com/en-us/library/ms733025.aspx http://msdn.microsoft.com/en-us/library/ms732023.aspx     Sample config: <configuration>   <system.diagnostics>      <sources>            <source name="System.ServiceModel"                     switchValue="Information, ActivityTracing"                    propagateActivity="true">            <listeners>               <add name="traceListener"                    type="System.Diagnostics.XmlWriterTraceListener"                    initializeData= "c:\log\Traces.svclog" />            </listeners>         </source>      </sources>   </system.diagnostics></configuration>   and use SvcTraceViewer.exe to look at the results.

Posted in Software Development | Leave a comment

Good SQL code for “input validation”

IF @param <> 0 AND    @param IS NOT NULL AND    NOT EXISTS       (          SELECT id…       )    BEGIN       //do something    END

Posted in Uncategorized | Leave a comment

(re) order columns in a datagridview programmatically

An initial search didn’t turn up anything, but some diving turned up what I needed: http://msdn.microsoft.com/en-us/library/wkfe535h(VS.80).aspx   "When you use a DataGridView to display data from a data source, the columns in the data source’s schema sometimes do not appear … Continue reading

Posted in Software Development | Leave a comment