David, both XP x64 and Server 2003 x64 where released back in April.

http://www.microsoft.com/windowsserversystem/64bit/default.mspx

And that function does a lousy job.. Here is an example of a function that does it much more efficiently.

CREATE FUNCTION dbo.fnListToSet (@list VARCHAR(8000), @delimiter VARCHAR(3))

RETURNS TABLE

AS

RETURN

...

Well, the error message is pretty much telling you where to look. The column IsActi*** (*** means whatever should really come here) seems so have a double quote character in...

What exactly do you mean by a complete rewrite? I am fairly certain that they did not start from scratch, if that is what you mean.

I am not sure exactly what you mean by "SS2005 fully integrated with Source Control". I would definitely not say that is true. SQL Server Management Studio (and BIDS) is...

"[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."

I have not tried accessing SQL Server 2005 with a JDBC driver (did some work with it on 2000, but not a lot there...

Can Enterprise Manager in 2005 access and manage a SQL 2000 server?

Well, there is no Enterprise Manager, but the new tool called SQL Server Management Studio (SSMS) can access and...

I am not in that camp.

I am in the "There is no such thing as denormalization"-camp.

Anyway, my primary concern when designing is data...

Without knowing the requirements behind this design we cannot say it is incorrect. For instance, if a Reactions should always have 4 mineral ids, then the original design would probably...

If the table is called bar and the column where Peter is stored is called foo, then this would give the result you want:

SELECT '' + foo + '' AS...

Do you mean that Table2 has 4 columns that refer to different rows (Min_IDs) in Table1? If so, then create the four columns with different names and you're set.

Are they saying that the problem is caused by a memory leak in SQL Server or the application (which I suspect they wrote)? If the former, how would they know...

I thought so, but I could not see what SQL Server would have to do with Java Server Pages. But since that was actually the original question of the thread...

Uhm, please specify what you mean exactly. At least, if not this works:

SELECT * FROM [tablename]

Can't remember for sure, but I see no reason to reboot the box after enabling AWE. SQL Server must be restarted of course. However, /PAE requires reboot of box, same...