I use SQLDiff (http://www.lockwoodtech.com) from time to time to generate scripts I forgot to save.

Not only does it show ALL differences between two databases, but it...

If you have Package Logging enabled, you can hit the sysdts* tables in MSDB. All the info you see in the GUI progress dialogs is buried in there.

Happy New...

....continued....

I use this to check if files exist and if they are zero bytes.

If you need more advanced conditional logic, you should steer away from DTS and use the Job...

Here's what I use....

--------------------------------

CREATE PROCEDURE dw_Check_Source_Files

(

@Result varchar(250) OUTPUT

)

AS

DECLARE

...

songmeister's method has always worked for me. quick n' dirty, true, but does the job. don't forget to add constraints that won't allow these dupes going forward.

As far as editors go, Homesite or Dreamweaver get my votes. Both have built in FTP clients as well as SourceSafe integration, without requiring FrontPage Server extentions as FrontPage...

Marcus,

http://www.w3schools.com has some great tutorials which is a good place to start.

http://www.aspfaq.com is not so much a tutorial site, but more geared towards troubleshooting. ...

The site is a bit slow today. Must be running both IIS & SQL Server on the same box! LOL

Here is a great article on the subject... http://www.aspfaq.com/show.asp?id=2120

ERWin is another handy tool. It hooks into your db via ODBC much like Visio. It is especially useful for reverse engineering a db.