Thanks You very much Arun!

Arun,

After performing the below steps , i should get back 504.27. That is my requirement.

-- The above output am placing into temp table "t001" and if i calculate the Avg()...

Thanks for the valuable info!

U r right!

If you have a look at "SQLVersion.JPG" attachment , u can clearly see that it is Enterprise Edition but not an Evaluation version.

How did got installed...

Thanks Guys! 🙂

Thanks Lynn.

Thanks Victor.

Is there any query to retreive the whether to know it is an Evaluation and Developer Edition.

Do you mean to say we can install the RTM version of SQL 2008 Enterprise Edition on XP????

I have also attached 2 screen shots.

Hi Jeff,

Even i got the same question in my mind. SQL Server Server Edition can only be installed on OS Server. but i have seen the scenario in an environment....

George, can you please give me more clarity on this!

upto my knowledge, in SIMPLE recovery model, the T-log gets truncated whenever CKPT occurs or whenever 70% of the T-log is...

Thanks for the valuable suggestions.

Thank You!

I will do the remaining part.

Thanks Jeff.

Thank You all!

Thanks Grieg. 🙂 I am convinced with your real example!!!