Sorry about the assumption Gail that you were an American. Those guys have natural disasters like we South Africans have Eskom power cuts, Union Strikes, and Taxi Violence. :w00t::w00t::w00t:

Luckily...

Hahaha!

Gila you sound like Doomsday Prophet. This is South Africa. The only natural disaster we know of so far is a flood 21 years ago that destroyed a town. Last...

Gila the reason we use mirrors is because this is for a stock exchange trading application.

If the database fails for some reason, the mirror kick in. If there is as...

Atul

Is it really necessary to make Transaction Log Backups every 30min/hour?

Well the company has n strong policy on the mirroring issue. So that ain't going away.

Currently Full Backup are made on a daily basis.

Transaction Log Backups I have tried, but...

So what your saying is, Atul, is take the Database off mirroring, make backups, set to Simple, Truncate en then reverse the process to mirror it again?

Just a bit of...

Just a note:

The Database is also mirrored on a backup server. Don't know whether that will make a difference to the whole scenario.

Somehow truncating the log just doesn't have any...

Thanks Paul.

It seems like I have to go back to ye ol' drawing board and rethink my approach to this problem. :unsure:

Well the formula in short works like this.

------------------------------------------

Get Last Value from a History Summary table

Get Summarized Value from a Current Transaction table

Insert the current value into History Summary so it...

Garadin ... the easiest way was using INFORMATION_SCHEMA.ROUTINES.

I have also implemented it in such a way that every hour a job runs a procedure that will compare a previous version...

THANKS diamondgm

Your solution works the best.

Problem is guys we are getting source safe next year so for now i need an easy and uncomplicated solution.

Well the problem is that I want this to be an automated process for all by procedures and functions.

If possible I want to auto schedule this for specific intervals eg:...

Thanks guys

OpenDBiff will do for know till the managers decide we can purchase SQL Delta.

OpenDBiff ain't the best I've seen but its free and at least I can see what...

Seems like I spoke to soon. The following ESSENTIAL Excel functions are not in SSAS-2K5.

Standardize

NormDist

NormsDist

Do anybody now whether there are function like those in SSAS-2K5?

http://msdn.microsoft.com/en-us/library/aa178231(SQL.80).aspx

The above link explains that these...

SQLBOT: I actually have written that function from the formula on Wikipedia. But for some re3ason it doesn't bring back the correct result. Not even close.

POWER(1/SQRT(2*PI()),-1*(POWER([@BINVALUE],2)/2))

Matt: I actually found that...