Try these two links one is a developer program that gives you MSDN cheap and the other is the regular customer pricing.  Hope this helps.

http://msdn.microsoft.com/howtobuy/vs2005/

https://partner.microsoft.com/global/40010429

Kind regards,

Gift Peddie

Try the links below to get the betas free.  But I have seen people getting problem with SQL Server from the mailed CDs so the second link is for you...

Try these links the first one is to clean out the failed install and the second is to download the June CTP.  Hope this helps.

http://blogs.msdn.com/astebner/archive/2005/06/14/429194.aspx

http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA

Kind regards,

Gift Peddie

If your databases are not large you can create a blank SQL Server 2000 database and move the data through BCP or INSERT INTO and DTS.  The reason SQL Server...

The ANSI SQL club on Yahoo tested the Microsoft RAND function and found it to be useless in the late 1990s and in .NET Microsoft tells you not to use...

I did not tell the person to just rebuild the Master, I also said the person should move the data before rebuilding the Master.  And at this moment I think...

If you read the  info in the link you will see the following

"You cannot alter the collation of a column that is currently referenced by:

• A computed column."

so your...

Temp tables cannot be in Northwind, Temp Tables are in TempDB an intermediate place to test code and also run long and complex queries.  There are two types of Temp Tables...

In SQL Server a UNIQUE Constraint can allow NULL while UNIQUE index cannot.  I don't think BIT which is boolean in SQL Server can accept NULL.  Try the link below...

Thanks for adding the computed column info, so try the link below for the not easy  solution from Microsoft.  Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp

Kind regards,

Gift Peddie

 Try the link below and scroll down to U through Z for sample code using CUBE and ROLLUP operators.   CUBE and ROLLUP are sometimes called super aggregates and I think...

I am assuming your columns allow NULLs in which case you have to add COUNT(*) to SUM because all SQL Server aggregate functions ignore NULLs.  Hope this helps.

Kind regards,

Gift Peddie

I am not sure about your needs but COUNT(*) is the only aggregate function in SQL Server that will NOT ignore NULLs so you may need

COUNT (*) and SUM together because...

I could be wrong but I think that information is in the Sysdepends table in the Master database.  Try the link below for SQL Server System Tables.  Hope this helps.

The error is very clear because SQL Server 2000 have column level collation and table X collation is in confilict because it is different so ALTER the table  to the database...