Must-have Excel add-ins you can’t afford to ignore Excel offers a robust set of tools to import data from various external ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database ... script to clear the Microsoft sample ...

If you store this information as plain text, unscrupulous users can easily steal the data either through online SQL queries or by scanning the files on the database server's hard drive.

In SQL Server ... the database file, and then press the Repair button to repair your database. Once repaired, you can save your data. You can save it in a new database or the current Live Database.