The GUI tools "Administrator" and "Query Browser", roughly equivalent to Enterprise Manager and Query Analyzer, are free. I find the Admin to be very flaky though, in my experience -...

I'd suggest using Michael's method. Managing unique IDs yourself when sql is perfectly capable seems unnecessary to me...

Chris

I'd say it depends on how many records there are in the source database, and what the purpose of the sql server system is. If there aren't many records, and...

Or this nice SP? I created this in master. I use a scheduled VB script to handle old file removal. Works for me.

Chris

=========

/*

usp_BackupDB

Backups up a database

Creates a .bak file in...

Do a search for: Collaboration Data Objects.

So between two pump tasks, you'll have an "execute sql" task that will contain the dedupe clean-up script. But we'd need examples if you want more help.

Cool - thanks Boris.

I wanted to know this too. I thought I'd reply and bring it back to the top of the pile...

Cursors aren't "very bad". They're one of many techniques you could use to do a job. If a select/update/delete command can be used instead, do so. But there are cases...

Hello again,

Just to let you know that I fixed this this morning! Turns out my IE was suppressing JS errors. When I tried from another computer, I got a message...

Hi David,

No, none. No error message on screen - it just ignores my button click. I check the logs for Reporting Services and IIS and nothing.

So frustrating, as the evaluation...

Ah, I didn't realise that. I've never managed to deploy RS2K successfully so wouldn't know...

Did you check the Multi-Value checkbox in the Report-Parameters menu?

Chris

It's no big deal - I already have a working query written, using subqueries. It's just that it's quite an ugly block of code to do a fairly simple task,...

Ah yes, almost forgot that I also meant to say...

In terms of how SQL Server executes my statement, how is that different to using a subquery?

Chris