Hello There:

I have been struggling over trying to get a sql script to work that sebstian one of the DNN guru's from Germany provided a while back. I am sending this inquiry to you because I feel you might be quicker at getting back to me than the other dnn guys and might have a useful answer.

Basically what happened was this. When DNN 7.4 came out for what ever reason the eventlog table was split into three joined by foreign keys so of course no longer can you do a simple truncate command so this Sebastian came up with an sql script that was suppose to work.

Upon testing it out I kept getting syntax errors. I replaced the obect qualifier with nothing and the database owner with dbo since that is how it showed up in my web.config file.

I tried everything leaving the braces in than taking the braces out and while monkeying a bit with the script file I got a lot of the red underlines off still there were unsolvable problems at least from my standpoint.

I didn't know if you could look at this sql file and tell me or perhaps even send me a sql script that would be fail proof for this purpose. I guess it is a fairly complex script that has to be used but no matter what I try to do I just can't seem to get it to work via sql server 2012.

Even if you could provide me with some kind of delete script that would delete x number of rows from the top that would at least be better than having to go through the steps of editing the top 2000 rows and than clicking on the first row and scrolling down to the last, holding down shift and clicking again.

Even if it was a script where you could change the number from 100 or perhaps 1000 etc... where it wouldn't cough I chose too many rows that weren't there.

At any rate the main point is if you could look at this script sabastian supplied and give me some ideas as to why it is failing syntactically with sql server 2012.

Thanks,

Bo

I'll assume that you don't use an Object Qualifier:

1. Start with Sebastian's script.

2. Replace {databaseOwner} with nothing.

3. Replace {objectQualifier} with nothing.

4. Paste the script into the appropriate box on the Host, SQL page, check the Run as Script checkbox, and then click the button to run the script.


(Please note that I am doing this from memory, and haven't tested what I just wrote.)

I got it to work as I was able to chat back and forth with sebastian but it was a tuff but after a bunch of back and forth I got it to work thanks though.