[SimonMac]

Even though I am no longer a BES Admin I've been pulled back into my old life for one job so am a little rusty!

One of the Scheduled jobs on our BES is failing because the SP RemoveDeletedUsers doesn't exist, would I just be able to recreate it using Darths example below?

BlackBerryForums.com : Your Number One BlackBerry Community - View Single Post - SQL DB Rename & Relocate

Is the generic sql script or has Darth tweaked it for his own needs (it looks like he has amended it to 180 days rather than the default 60), if so can anyone give me the original?

[hdawg]

What version of the BES database schema are you running (exact version including SP please)?

To find this out, connect to the BESMgmt database and execute:

select * from serverdbversion

The value I'm looking for is the highest DisplayVersion ... attached is a screenshot of what mine is displaying ... on a BES 4.1 SP5 server.

[SimonMac]

Interesting, its showing 4.0 and 0.0.403 as the highest but the BES is showing 4.1.4.12?!?!

[hdawg]

Can you post a screenshot? oddly the screenshot I posted got trimmed somehow.

[DarthBBerry]

I didn't tweak it. That's what RIM sent to me when I requested it from them again! Blame "the man!"