SQL Server From .Net: Connecting Visual Studio Community Edition

This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon.

Max DB Size for SQL Server Express

Installing Reporting Services on SQL Server 2005 Express Edition

Having completed our coverage of the Service Broker characteristics specific to SQL Server 2005 Express Edition, we now turn our attention to Reporting Services. In this article, we will present the initial setup process, leaving discussion of configuration, management, security, and usability for future installments.

RE: Database Results in Frontpage

http://www.powerasp.com/content/new/using-frontpage-to-set-up-a-database-connection.asp

DTS - Cant drop table not in System Catalog??

Hi there,I've created a DTS package to copy 1 database to another and scheduled it as a job. However, it keeps failing on the same task with the error message..."Cannot drop table [tablename] because it does not exist in the system catalog"The package is designed to drop/create and copy tables and data for each table […]

RE: help selecting sums from two similar tables

What the problem is, is that I need to get a sum of all transactions for a month, on a per month basis. Tables are basically: table1: docamnt,date 12.37, 1/12/2003 25.01 1/15/2003 11.45, 2/20/2003 table2: docamnt,date 32.17, 1/12/2003 200.56, 2/20/2003 Anyone know how to join these tables together so that I get all transactions for […]