When storing SQL scripts in a database project, that are not stored procedures, VS will give you some grief.

Build Error:

Error    6    TSD7025: Unable to identify the schema type contained in the .sql file.  A schema type of 'Procedure' was expected, based on the name of the .sql file.

 

To get around this, update the properties of the file in VS to “Not In Build”.

Thanks for listening.

When attempting to install the SQL Server Client Tools (for SQL Server 2005 Standard and Enterprise) after SQL Server 2005 Express in already installed, the installation program throws an error:

This error pops because under the covers, the default installation of SQL Server 2005 Express installs a couple of the same client components that are installed with the larger tool set.

To correct this you need to remove the client tools installed with Express and then install the client tools from SQL Server 2005 Standard (or Enterprise).

Here’s how:

Uninstall SQL Server Express Client Components

1. Open the “Add/Remove Programs” (“Programs and Features” on Vista) from the Control Panel.

2. Scroll down to and select “Microsoft SQL Server 2005”

3. Click the “Change” button

4. In the setup application, select the “Workstation Components” option

5. Complete the uninstall wizard

Install SQL Server 2005 Client Tools
You will need the SQL Server 2005 Standard (or Enterprise) installation disk(s).

6. Install the SQL Server 2005 Client Tools using the installation wizard

Thanks for listening.