Like I said, I am not aware of any user defined global variables in SQL 2k. But I suggest a solution. Say, you have a table with two columns, VarName, VarValue that acts as a list of name-value pair. You could write User defined functions that read-write data for each name-value. Here is an example. VarName VarName ------------------- City London Country UK Then you could write UDFs like GetCity(), SetCity(), GetCountry(), SetCountry() etc Farhan Noor Qureshi if (this == this) thow this; -- modified at 13:46 Tuesday 29th November, 2005

Yes, but dll files can be decompiled and you can find the value and modify it in the binary. I used to do it to change the colors displayed in a simple enhanced directory list conosle application all the time. The only thing that really prevents customers from making the changes is your license agreement with them. If you are really concerned about it then bury some code in the applicatin that uploads the setting to your servers periodically and then verify it with what they purchased. It is probably better to make it easy to add licenses then chase after people that cheat on the upgrade. At least you got some money out of them. 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

You need to declare the bool variable with the volatile qualifier, without it, there is no guarantee that setting it to true would immediately reflect in the other thread. Regards Senthil _____________________________ My Blog | My Articles | WinMacro

Because sometimes i open a web file by flash menu so Response doesn't work this case :(. Is there anyway to set all your project's web pages no-cache (such as in web.config)? Thanks your reply :)

Thanks your help! :)

Yes, it is :) But if we open a web page this way, does it need to login again if it need to authenticate ? Because i need the just opened web page get the authentication of the web page opening it Thanks your reply :)

Ah, so the installed project doesn't need these files!!! I got it now Thanks for reply :)

Thanks a lot! I did it! :-D I don't know why if i set in the .NET Framework machine.config file and then in the web.config file i code like this then i try to run the project, i can't :( But if i set in the machine.config, the project works fine! :-D Really don't know why but thanks you, everything's fine now! Thanks again! You don't know how it's important to me :)

I'll try it! Thanks! :)

SQL and .Net use different rounding algorithms (as you have observed), ao the answer is that you can't. Net's version is the more 'proper' algorithm: it returns the nearest even number when the value is half way between (.25 will round to .2, .35 will round to .4) This yeilds more accurate averages and totals for the rounded data, and so is prefered. It is sometimes called "Banker's rounding". SQL always rounds to the next larger number for the mid value, which leads to totals and averages that are biased to the high side. I would recommend choosing the rounding behavior that you prefer, and always doing the rounding that way (i.e. either have ONLY SQL do the rounding, or ONLY .Net). I suspect that returning unrounded values from SQL and doing the rounding in .Net would be marginally more performant. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer

Thanks! Your direction really works! :)

I'm really sorry, Graham! I didn't mean it. Because i don't know which forum the question is suit to ... Besides, i used to face a similar situation. I used to posted a question in C# general but no-one answer me because posting it in SQL is more exactly ... So ... I'm really sorry. I will never repeat it again. By the way, thanks your reply! :)

.NET remoting? No, i've never heard of that. Thanks your suggestion. I'll try it. :)

I've just found some articles about Windows Service. I thinks this will help. Thanks your help! :)

You need to check the difference between now and a time you stored ( when you last allowed access ). Then it will work. Christian Graus - Microsoft MVP - C++

I'd check for open transactions..that aren't being committed/rolled back etc..

Blue_Skye wrote: You're right, it really works... I know, I learned it here! :-D I'm glad to have helped you. Good luck! :) -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!

I'll try your solution. Thanks! :)

I tried your solution but there's an error appear: It's say that ltlAlert is a null referenced object. Besides, there's a error while rendering the page too. I don't understand why we have to have this code : EnableViewState="false"> Can you help me out! Thanks for your reply! :)