The maximum number of tables in a select is 256.

SQL 2000 http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx

SQL 2005 http://msdn.microsoft.com/en-us/library/ms143432.aspx

Those are the maximum capacity specs for SQL 2000 and 2005, I...

From my personal experience, installing 2000 first followed by 2005, installing 2005 first followed by 2000 broke...

brewmanz.sqlservercentral (4/16/2008)

Yes, many of us have said this, including me. But I've yet to have the acknowledgement that our clearly correct answer-that-works...

Can I change my answer to

E: You should have recognized this as the April Fools Day question, one day early.

Seriously, as someone still learning...

This is actually much cooler than it looks - a poster above noted this but I did not understand until I tested...

If you specify a column alias that matches a...

My gut reaction when I first saw this was to choose the "correct" message, then I tested this on my SQL 2005 and SQL 2000 servers, and both times it...

Then I uninstalled SQL server 2005 and then installed SQL server 2000. When I try to connect to SQL 2000 it gives...

Thats the generic "I can't connect to the SQL server" that .NET 2.0 uses. The hint about SQL 2005 is less than useless in my opinion, because this message...

We got into just this sort of thing converting some legacy data.

The old system had tickets, items, and fees. The items were linked to the tickets, the fees were...

We have similar issues with our software, which is written in VB.NET

If you are the programmer of the .NET code, take a look at the commandtimeout property on the troublesome...