Well make sure you don't delete the backup history logs.

Also check to see if this returns something.

...

4 :

where createdon <> DateResolved, group by createdon

Looks awesome.

I'll definitely play with this even if I have to use the bazooka! :hehe:

Try this...

If the 1st table returns data then just copy / paste the object. That should work but it could fail if you search the controls by names if...

My script assumes a few things :

- The backups stay where take them (don't move then after the fact).

- Each database has more than 1 full backup in the...

No that works only for sql and agent logs. I want the windows application et al. logs...

and I'm on 2k5!

Not too sure of want you want to do.

Do you want to put 2 tables side by side and present the data differently in both sets of columns?

If that's the...

Whack the index reorg from the plan and rerun again tonight (or earliest convinience).

Then put this in place (daily if possible).

http://sqlfool.com/2010/04/index-defrag-script-v4-0

Hey Lowell, got any code that reads the windows log that you can send over? I've found the link on SSC but the code is broken.

I'm...

Then put that code in a proc and test the front end app to death...

Plan A would actually be to fix the application in the first place so that this...

Very well said!

... and yes Navision is slow as hell even on a good day. It's just the way it's been coded and there's nothing you can do about that.

Not at all. The only difference with simple and full is a little more data...

pujain (6/27/2011)

---

thats the problem, we cannot run it in test enviorment as the code we are planning to give them are just one liner like

"update tablename set columnname=1 where...