Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server ...

The tool provides a variety of impressive database-management features, including SQL scripting, query building, object management, project management and version control in live databases.

With SQL Server, you need to grant access to three areas: SQL Server, the database, and the objects in the database such as tables and views.

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...