T-SQL insert using SSIS Data Pump

This article describes a T-SQL procedure to insert data using the SSIS Data Pump

Administration

Basics of XML and SQL Server, Part 2: Shredding XML

In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.

Basics of XML and SQL Server, Part 1: Streaming XML

This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files

Dynamic Select Generator

Query to generate a dynamic Select statement from any table for moving data between servers.

RE: Comparison operator *=

Good article reference, Frank (and congrats again on the MVP!)  I did not know about precedence of when the WHERE clause gets evaluated between the two forms.This begs a question of me, though.  I recently wrote the following code:select distinct fieldlist blahblahblah.... from EntityHistory en join enLookupCodes lc1     --get state  on ad1.refstateid = lc1.id join enEntityAddressTypes […]

RE: sp_who2 output

I was taught to NEVER, EVER, EVER change a system stored proc, so I created a wrapper for sp_who2 to display the results in the order I wanted (order of cpu usage).  (By the way, I think Calvin's suggestion is perfectly valid, and won't really affect much if the fears of those who teach the […]

RE: SQL MAIL - URGENT

Are you able to upgrade to Outlook 2002?I did a google search and found a similar problem where MS support suggested the upgrade and it fixed the problems. 

RE: sql job does not run

If you use the propre sp, things whill work fine.This is because these procs also tell the running sqlagent to refresh its job-data.I use it all the time when e.g. I schedule db-maintenance, the first thing I do is disable the incremental backup job plus leaving a notification.I do it this way : EXEC MSDB.DBO.sp_update_job […]