gives new meaning to "flushing the cache" :-O Steve

About leaky code... I suggest you get yourself a profiler. True lifesaver. There are bugs that are nearly impossible to find without one. Try the one from SciTech... memprofiler.com[^]. They also have a great tutorial on the website. Alex Korchemniy

You can set SQL server to a maximum memory usage, otherwise it just uses memory until the server starts paging. Increasing the page file should fix the problem as well, but then you would be causing the server to page which is a bad thing for performance. Better would be to move your process off the SQL server, or find a different algorithm. I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

See the DataRelation class in the .NET BCL. It's pretty straight-forward and easy to make a typed DataSet by right-clicking on your project (or a folder under your project, which helps set the default namespace for your source files you add to them) and adding a new type, then choose DataSet. You can even drag and drop tables, views, and stored procedures from the server explorer to create elements (the DataSet designer is, after all, just the XML schema designer) that represent tables, while their elements represent fields. You can create primary keys and draw relationships. When you save this, it serializes using the CodeDomSerializer so that you have source code. When you use it, instead of using DataSet ds = new DataSet();, for example, you would use MyDataSet ds = new MyDataSet();. That already has typed table and fiend names, as well as relationships established. Note, however, that the DataAdapter derivatives - or rather the command builders like SqlCommandBuilder - don't support auto-generation of complex statements required for updating a data source with changes. All this is programmatic changes you can do manually, as well. It's most important to read the documentation, but you might also makes a typed DataSet in this manner and examine the source code (click "Project->Show Hidden Files" in the menu to see the source file itself). This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog]

How many times to do I have to say this: if you're getting an error, tell us what it is? How do you expect us to help you? Using directory services is the preferred way, and in most cases the only way. Microsoft MVP, Visual C# My Articles

Dispose does not remove a connection from the pool. Marcie http://www.codeproject.com

The only way you'll be able to do this is to extend the PrincipalPermission and PrincipalPermissionAttribute classes, or create your own. You could do the very same things, except check the Type against WindowsPrincipal that you get back from Thread.CurrentPrincipal. The current implementation doesn't care about the Type, so long as it implements IPrincipal. If you want to know exactly what the current classes mentioned above are doing, you can use ildasm.exe that ships with the .NET Framework SDK if you know IL (and it wouldn't hurt to know anyway), or use a good decompiler like .NET Reflector[^]. Microsoft MVP, Visual C# My Articles

Sadly not. That's to ensure that the amount of time estimated roughly resembles the reality after the project. --Colin Mackay-- EuroCPian Spring 2004 Get Together[^]

you could generate a RTF or HTML file and open it in word. or you could generate a XML compatible format if using office 2003 "When the only tool you have is a hammer, a sore thumb you will have."

No, there are no classes in the .NET base class library that can do this, but there are ways you can P/Invoke the necessary functions. Search the comments for this forum, as I know we've talked about it before. I also remember seeing an article or two here on CP about the topic as well. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

You can't, actually. .NET Installer classes have nothing to do with Windows Installer, Windows Installer is just able to run them as custom installer actions. I was talking about native custom actions that you'd have to write in C/C++ (with C-style functions). The easiest way is to install Orca and edit the MSI yourself. Just go to mdsn.microsoft.com and go to downloads. Click Platform SDK but only install the Windows Installer SDK. It will install only a few required components from the PSDK itself. Legally, I cannot just send you the installer for Orca but it is an invaluable tool and is worth the download if you're messing with installer packages. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

Not at all. I'm still using Trillian... ;) Anna :rose: Homepage | Tears and Laughter "Be yourself - not what others think you should be" - Marcia Graesch "Anna's just a sexy-looking lesbian tart" - A friend, trying to wind me up. It didn't work. Trouble with resource IDs? Try the Resource ID Organiser Visual C++ Add-In

Let the world take to record that message number 632981 is for Vikram. :jig::beer: God Bless, Jason DavidCrow wrote: It would not affect me or my family one iota. My wife and I are in charge of when the tv is on, and what it displays. I do not need any external input for that.

Unfortunately the IE AX installation mechanism only works with CABs. --Mike-- Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber Latest art~!@#2rDFA#@(#*%$Rfa39f3fqwf--= NO CARRIER

Go for it man! They provide you with instant support if any problem arises. We have been with Web Host 4 Life for the past 1 year satan

Nishant S wrote: Dunno Take the test at http://www.humanmetrics.com/cgi-win/JTypes2.asp :cool: I'm an INTP, so is JoeSox [joke]who blasphemously calls himself JoeSwammi (as opposed to JoeSwami) [/joke]. Marc Clifton is prolly one, too. Famous ones: Einstein, Hepburn, Dukakis, etc... Take the test when you can and let me know what you are- I'm really eager to know. On a side note: Nishant S wrote: I am rather shy and introverted Contrasts your CP "life", eh? ;P Actually, that's not surprising- most Ixxxs are very Internet-active (assuming there's such a term ). Me too. And check out Joe's latest article at http://www.codeproject.com/useritems/Carl.asp . It's :cool: . Vikram. ----------------------------- My soon-to-be-updated site KI klike KDE kand kuse kit, kbut KI kmust kadmit, kstarting kall knames kwith K kis ksilly. KI khope kthey kwill kgive kup kthis kwhole kscheme ksoon kand kcome kup kwith kreal knames. pI vThink aHungarian nNotation vIs iA aWonderful nThing cAnd pEveryone avShould vUse pIt aAll dThe nTime, adNo nMatter pWhat dThe nContext, adEven adWhen vSpeaking.

If you are using XP, go to control panels, system, startup and recovery. Uncheck the Restart on error box. Now you will get the BSOD instead of restarting, and you will be able to read the error message. Hope this helps.

David Wulff wrote: I lived for the little cries of "Yipee!" when the geologists found gold! :-D I am not alone then, wonderful! I loved watching those chaps scramble over the hills tapping away and then putting down markers. In general though the SFX in Settlers was brilliant. The birds, the threshing of corn, the creak of the ships, all superb. *sigh* There goes my day *Paul gets out his well worn Settlers II CD* :-D Paul Watson Bluegrass Cape Town, South Africa brianwelsch wrote: I find my day goes by more smoothly if I never question other peoples fantasies. My own disturb me enough.