Consider setting up full-text index catalog on this field, and do a CONTAINS query.  Much faster.

I understood that.  That is why restoring a backup is the best way. 

Using DTS is like using an 18-wheel semi to go to the corner market for a loaf...

I disagree with using DTS like this.  DTS is much too slow to use for database copy operations.  I would prefer using detach/copy/attach route, as that would only take a...

You CAN "lock down" MSDE.

1)  Install MSDE into it's own instance.  You probably want to name the instance with your product or company name, so someone can tie it back...

1) MSDE 2000 SP3, MSDE 2000 SP3a, and MSDE 2000 Release A are all the same; Release A has a slightly different setup program.

2) All the MSDE releases (incl 1.0...

Re: "a clustered index that has been incorrectly set as non-unique."

I hope that you do not mean that just because its clustered index, it must also be unique.  You certainly...

Yes, MSDE can be used for production environment, as long as you follow MSDE licensing terms (basically, if used for an application developed using MS tools).  If loads are low,...

And in QA, you can always use sp_help <tablename>.

There are some other products (Embarcadero comes to mind). But, IMO, none that offer significantly greater advantage over MS builtin tools (at least not worth the extra cost).   Unlike...

Not sure exactly how the msolap is setup on IIS, but if you can get it to run as a IIS Out of Process application, then in Component Services set...

Since you mention ASP pages, I assume this is a web application.  If your users are authenticated (NT Domain or AD) users, you can use the first or second option,...

That is true, but the connection info is still being stored in plain text files (.asp file).  There have been IIS security holes that allowed retrieving the file as text...

"The way to go" is to not connect to SQL Server from ASP code.  Put all data handling (SQL queries) and "business logic" in ActiveX DLL(s).  Pass disconnected recordsets back and...

This is a link to template file I used on a project for sending table updates to multiple clients.  It demonstrates using vbscript to use DMO objects to backup the...

My preference was to use VBScript and use the SQLDMO and BulkCopy objects, then use error trapping in VBScript.