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.

I am using SQL Server 2000 Developer Edition with VB .NET 2003 in case that has any relevance.<BR><BR>My basic question is; is this normal?

1.) Yes, a stored procedure is the best way because 1. It's better on the server performance wise. 2. Easier to update a query that is stored on the server than a adhoc query in your application ...

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.