Jeff is right and ANSI SQL limit for OUTER JOIN is four you have five and Sums in an indexed view cannot be nullable.  Try the link below for more...

Embarcadero DBArtisan can be used for most RDBMS(relational database management systems) and it is less than $10,000 dollars.   Try the link below to test drive it.  Hope this helps.

http://www.embarcadero.com/products/dbartisan/index.html

Try the link below for guidelines to SQL Server DateTime data type use and known issues and limitations.  Hope this helps.

http://www.karaszi.com/SQLServer/info_datetime.asp

Kind regards,

Gift Peddie

Japanese_BIN means Japanese Binary sort order which tells SQL Server it must be case sensitive because case sensitivity is required for SQL Server Binary sort order.  So SQL Server is...

You could create jobs to run DBCC shrinkfile on both databases and SQL Server will return space less what it calls active log. You have to decide how many times...

I am not sure if you can use the list with SQL Server 2000 but the links below is the complete code page and collation listing for SQL Server 2005.   Hope...

Yes one of the reason the Agent is the best thing in the product, the Agent can run your enterprise.

Kind regards,

Gift Peddie

Print out the 18 pages in the link below and you will understand the internal mechanics of the Query processor, the paper was created for SQL Server 7.0 but it...

It seems you are Updating a UNION ALL View which is what a Partitioned view is by default with stored proc but you cannot do that because you are updating something  not...

In SQL Server 2000 and below a Full text index uses the Full text Catalog in Microsoft Search service which is a separate install.  If you use CONTAIN and FREETEXT...

Start with sp_who and sp_who2.  Try the link below for more info.  Hope this helps.

http://www.mssqlcity.com/FAQ/Admin/current_users.htm

Kind regards,

Gift Peddie

The reason I don't know but print out the eight pages from the link below it will show you how to create location neutral DateTime for your database.  Hope this...