SQL Server 2005 replaces these two utilities with SQLCMD. This new tool provides a couple of useful tricks that help you process SQL scripts. All of the SQL Server utilities, including Query Analyzer, ...

The Show Script button generates the actual T-SQL script to be used in SQL Server Management Studio to clear the database. See Figure 6. This button can be the first one clicked after selecting the ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment.

Save that batch script with a .bat extension, like GetCSV.bat. Executing that batch script will open up an ftp connection and fire off your commands resulting in filename.csv being downloaded.

I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy ...

It is, however, good coding style to indent the code for different control structures in your PL/SQL scripts the same way you would in other programming languages.

xSQL Software, a provider of SQL Server auxiliary tools and utilities, announced today the availability of xSQL Object 1.5, a utility for SQL Server database administrators and developers that ...