Andy Warren

Occasionally I come across a free or relatively inexpensive (under $100) tool that makes my life easier. If you've used one that I haven't reviewed, send

A few weeks ago I published an article about modifying replicated tables with SQL 7. If you haven't read that article, I encourage you to do so before

I've gathered a few more interesting bits of information about DSN's that I'd like to share with you this week: From Swynk reader Rod Burke: Basically, if

In a previous article (DSN) I discussed the basics of DSN's and the different types that you can use. In this article I'd like to continue that discussion

This free utility lets you build multiple DSN's (system, user, or file) quickly. It's not a tool you'll use everyday, but when do use need it, it's a real

If you've used transactional replication you're probably familiar with the step in the wizard where you have to pick either continuous or scheduled for

If you've set up replication without immediately updating (or even queued updating in SQL2K) subscribers, you may see this error if you allow write access

Replication is a pretty nice feature, right up until you want to make a few schema changes. SQL 7 will not let you alter the schema of any table that is

These code samples illustrate how to enable and disable all triggers in a database at one time - a task not easily done otherwise! If you haven't use DMO

DSN is an acronym for Data Source Name. It's a simple and standard way to describe how to connect to a data source using an ODBC driver. More

I recently had to move several databases from one server to another and ran into a problem with transferring the SQL logins. If you take a look at SQL 7

SQL-DMO (Distributed Management Objects) provides a programmatic (COM) interface to SQL Server. Its a great tool for automating routine tasks far more