Does this mean i am using sql server 7

Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86)   Apr  9 2002 14:18:16   Copyright (c) 1988-2002 Microsoft Corporation  Standard Edition on Windows NT...

Nothing specific

when i run this commend it give me below detials.

which version is it?

Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86)   Apr  9 2002 14:18:16   Copyright (c) 1988-2002 Microsoft Corporation ...

@@version

 command is not running !This is giving me following error!

Server: Msg 1044, Level 15, State 1, Line 1

Cannot use an existing function name to specify a stored procedure name.

This was a very clear reply!

Thanks a lot

Does this mean that it was th eproblem with indexes!

and running above commands will update the indexes!!

Does this has to do any thing with the query i wrote???

Well i am not a database guy but i work on sql server quite offten but only to an extent ofqwritign sql queries.

But when i was turning some books...

check the below link ,i got something about daylight saving!!

http://www.msusenet.com/archive/index.php/t-1964387.html

Hope this will help you

Thanks for the so many replies,i hope i will not loose the

interest in exam 70-229.

The only key is to study hard and practice a lot.

Thanks Pal

Thanks i will check out the book and the microsoft site also!

Is there any site or link available where they have mentioned the percentage of question asked  from each chapter.