Weird I just cut and pasted the last sql statement that I put and said I was getting errors just to try again and this time it was success. Not sure the difference maybe I had an extra space somewhere but it seems to work now. Thanks for your help. By the way why was it that in my case I wasn't suppose to use ""- as an empty string for the object qualifier.
I do have one more question which I guess should be a different thread but was just wondering if you had a quick answer for it. I have had issues with my dnn app continually recycling. I did turn off all the time limits but discovered I missed setting the regular time interval under the recycling category to 0.
-----------------------------------------------------------------------------------------------------------------
I site I saw suggested setting the limit interval to o under CPU
The idle time out to 0 under PROCESS MODEL
Lastly regular time interval to 0 under RECYCLING.
--------------------------------------------------------------------------------------------------------------
But my question is this. One person said that they turned GENERATE RECYCLE EVENT LOG ENTRY > REGULAR TIME INTERVAL to FALSE.
I was wondering if that was really necessary or if it was another property needing to be tweaked to prevent app shutdown during idle moments without having to use a continuous pinging service that pings once every 5 minutes.
Another suggestion someone had was applying disallowRotationOnConfigChange or turning it to true or on but the question came up that even if you did this in order for it to really take the effect you were looking for you would need to do the following
---------------------------------------------------------------------------------------------------------------------------------------------
There is a File Change Notification (FCN) registry change that can prevent web.config changes from causing an appdomain recycle, but then the changes themselves won't be picked up either until the app pool is manually recycled..."
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
My question is would the above change be wise? It seems as though it doesn't really matter weather you turn it on or not in regards to preventing app shutdown if you have to manually recycle anyway to have a web.config change to be applied. It almost seems like in reality it wouldn't really be an asset since when you make a change in your web.config file you expect it to be applied so it is reflected in your dotnetnuke app so why would you want to turn it on just to be forced to manually recycle the app for it to apply when it would do so automatically otherwise.
Anyway if you could let me know if this registry key change is a good idea or would further help prevent unnecessary restarts I would appreciate it I feel if you are changing web.config having it applied to your live site is necessary but let me know what your assement would be I am using a vpn that I have full access to windows settings so I can do anything a full fledged web admin could do. Thanks, Bo.