Well, a couple of your problems are because things aren't quite obvious. You can design a GUI query when things start by right-clicking the query window, I believe. ...

There's a forum? I've completely missed that. This is a really useful product for the cost. One of the few things that I've actually bought right away....

Actually, if I could get a mac that would dual-boot Windows and OSX, I would consider making the switch. However, the way things stand right now, I can't justify...

I beta-tested the app and bought it almost as soon as the buy link was available. It worked great for me under Query Analyzer, SSMS beta and SSMS release....

Just a follow-up to this - if you have a lot of data to work with, you'll probably be better off loading to a staging table where you can scrub...

I'd probably save it on the SQL Server and run it again using Enterprise Manager to navigate to the DTS Packages folder, then run the package (either right-click to run...

Have you considered the Custom FTP Task @ http://www.sqldts.com? It's pretty good and worth checking out. Only drawback I've found is that the data that drives it is...

Doing something useful that has a tangible impact is always a plus. Typically designing the middle/back-end processes that do something is enjoyable over the UI.

Automating of regular processes -...

Stage all of the data into a holding area, then export to one text file? Export to several temp files, then use a Command task or even VBScript if...

Not sure about DTS packages - looks like SSMS may install an updated version of the DTS dll's and that may cause issues deploying to a SQL 2000 server. ...

Just a caution on that method - I was using it successfully for a while and then it just stopped working. No errors, no warning, just no execution. ...

Depends on what you're planning to do. I would plan the clustered index carefully as that defines the physical order of the table. If you'll be doing a...

Any chance that that same developer had made that combination of FK's into a Primary Key/Clustered Index? I've seen that before and performance is hideous. That's where you...

Well on that note, there are some parameters that can be set for different deployment scenarios. I don't typically have that much to change so this isn't a huge...

If I recall correctly, Ent Mgr has a button in the Table GUI to manage indexes. Create a new one, choose the appropriate columns and sort order, give it...