Thanks Steve, some useful stuff there.

Just one small note, in Profiler you don't have to create a new trace to add events. If you pause or stop your trace, you...

Thanks for the well written, straight to the point article. Continuing Professional Development (CPD) is a huge area in itself. The British Computer Society (BCS) recently changed their program of...

Unfortunately, most CPU architectures use the same number of Watts irrespective of what they are doing. Only some modern laptops can reduce their power consumption (by dropping clock speed) depending...

A quick-and-dirty method would be:

declare @i int

set @i = 128

while @i < 256

begin

--print cast(@i as varchar) + ' ' + CHAR(@i)

UPDATE yourtablename

SET thecolumn = REPLACE(thecolumn,CHAR(@i),'')

set @i = @i + 1

end

Yea, I guess I could do something along those lines (although I seem to remember having serious problems with MSSQL seeing virtual drives, so I'm not sure this would work).

I...

Unfortunately I only have the complete backup, not the individual MDF and LDF files. I know that with the MDF, I could use sp_attach_single_file_db

to attach the database and a new...

I would certainly like to hear other views, but my 2 pennies is that snapshot replication would be more efficient than dropping/recreating tables. As long as the vast majority of...

Not quite sure what you mean by changes to a database?

If you want to copy data from one SQL box to another, and the second box requires a read-only copy...

hmm, good point. However, the main problem here is the variation between US date format, rest-of-world date format (ok, not quite true) and ISO date format.

I would like to recommend...

If you want to guarantee that Regional Settings (of the user, the workstation, or the server) do not cause havoc with your dates, I highly recommend passing dates to the...

"Professional SQL Server 2000 Programming", by Robert Vieira, published by Wrox, gets my vote.

hmm, interesting scenario. It is possible to interpret the MSSQL licence both ways - you either need a CAL for each application, or a CAL for each user.

The waters definitely...

Ok, I was being a pedantic.

As a follow-up question, how do you pass variables into this custom DTS? For example, I have a table with email addresses, subject, body, etc;...

The official answer is you need a licence for every single discrete device that connects to MSSQL. For example, you may have a single website connecting to a backend MSSQL...

I am a bit confused. In the description, it says:

"It does not require any software to be installed"

and then the next section describes how to install the DTS custom task....