Open up Management Studio, connect to your server. In Object Explorer, right click on the Server Root and select "Properties". Under the "Memory" page, enter a value in the "Maximum Server Memory" textbox. The change will take effect when SQL Server is under lesser load and can shed some memory or when you restart the service. SG Cause is effect concealed. Effect is cause revealed.

thank you for your answer, but is'n this going to cause a recalculation of the value of the alias?

Try something like this: SELECT t1.Field1, t1.Field2, t2.Field3 FROM Table1 t1 JOIN Table2 t2 ON t2.JoinField = t1.JoinField WHERE t2.IdField IN ( SELECT TOP(10) t3.IdField FROM Table2 t3 WHERE t3.JoinField = t2.JoinField ORDER BY t3.IdField DESC ) It is called a correlated subquery.

You can. Read up on C++/CLI if you use VC 2005, or Managed C++ for earlier versions of VC. --Mike-- Visual C++ MVP :cool: LINKS~! Ericahist | PimpFish | CP SearchBar v3.0 | C++ Forum FAQ I work for Keyser Söze

Have a llot at LOWORD and similar macros on MSDN http://msdn2.microsoft.com/en-us/library/ms632659.aspx[^]. :) If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.

Hi, To reduce the memory consumption : 1- Use the jpeg format 2- Specify the compression level 3- Always dispose graphics objects, pens, images,.. and set them to null Here some code to specify the compression level : private static ImageCodecInfo GetEncoderInfo(String mimeType) { int j; ImageCodecInfo[] encoders; encoders = ImageCodecInfo.GetImageEncoders(); for(j = 0; j < encoders.Length; ++j) { if(encoders[j].MimeType == mimeType) return encoders[j]; } return null; } private void SaveJPGWithCompressionSetting( Image image, string szFileName, long lCompression ) { EncoderParameters eps = new EncoderParameters(1); eps.Param[0] = new EncoderParameter( Encoder.Quality, lCompression ); ImageCodecInfo ici = GetEncoderInfo("image/jpeg"); image.Save( szFileName, ici, eps ); }

Use GetGraphics from the control of which you want save the content, then use the DrawImage method on the graphic context this gets you to draw the content to an image. __________________________________________________ Standards are great! Everybody should have one!

Hello, Maybe if you implement System.Windows.Forms.IContainerControl. All the best, Martin

SendKeys class works only on the currently focused contorl. If you want to send keystrokes/Mouse clicks to a control, you have to get its handle and pass it to a SendMessage API function call. You'd send a WM_KeyDown message I believe. Here is a link[^] on how to make a PInvoke call to the function. Ps. Sometimes -though rarely-, you'd have to send another WM_KeyUp message after the WM_KeyDown message. Regards:rose:

Thank you for the reply. I am not used to using any of the macromedia products but here's a good reason to try them out :-) As soon as I finish the control i will write you back. Thanks once again.