Do you have AWE enabled?

Can you verify the size and location of a paging file?

What is the version of Windows server? (standard, Ent.)

Do you have /3GB switch in boot.ini?

Did you see this http://support.microsoft.com/kb/316749?

You can use -g startup flag to increase the size of the memory: http://dbakb.com/kb/Default.aspx?Page=memoryleak&AspxAutoDetectCookieSupport=1

H-m-m... And what MySQL has to do with SQL Server dedicated forum?

As Gail and Jeff mentioned it all depends on your criteria list and contents of the project.

Until recently commonly used for performance measurements TCP test will give you a certain...

It is not an error. It is an entry in a log file. When the code of error is different from 0, then it is an error.

Glad you figure it out! 🙂

/qb versus /qn was in the list of my next suggestions. That is a great tool for debugging.

Can you please specify a full command as you are submitting it?

Are you running a default instance?

Lawson, ha?

OK.

I am not going to criticize this sproc, even so you are messing a lot with temp tables and table variables with the same names.

1. In the fragment where...

gardenlady,

can you please post your stored procedure here?

Message header is asking about uninstall.

Message is asking about install.

Here is install http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx

Here is uninstall: http://support.microsoft.com/kb/909967

cardgunner,

I did not answer your problem. Original post is published by gardenlady.

According to a very brief description of a problem that you are having - it is exactly in the...

Please, do not cross post.

Original post is here:

http://www.sqlservercentral.com/Forums/Topic579405-150-2.aspx#bm579901

Ideally you would have to publish your stored procedure here. It is my understanding...

It wasn't that difficult after all 🙂

Syntax error in your statement:

use adventureworks

;WITH CTE1 as ( Select AddressID from Person.Address

where AddressiD in (select ProductID from Production.Product))

Select * from cte1