Hello there, the correct query is here SELECT Name from tab1 where dt < #1/1/2008#

Rahul Goel Microsoft Cerfied Solution Developer .Net Contact me at : rahul.g2510@gmail.com

Hello Sandeep, Indexes are created for faster retrival of data. Its like searching a topic in a book with the help of index in book. Imagine if have to search the topic in a book without an index. It will be slower as you have to browse through each an every page to check for the topic. Indexes are of two types 1) Clustered index 2) Non clustered index. For more information about these two type index you can check books online of sql server Everytime you create a primary key using enterprise manager, it by default creates a clustered index. But thats not mandatory. You can have a primary key without any index. Its because its recommened to have a clustered index on a unique column. I hope I answered your question. please let me know incase of any query.

Rahul Goel Microsoft Cerfied Solution Developer .Net Contact me at : rahul.g2510@gmail.com

yeah It is possible but in this case you need to design one page which will take input and will generate the final report, but if you are using crystal reports then it is not possible. Cheers!!

Rahul Goel Microsoft Cerfied Solution Developer .Net Contact me at : rahul.g2510@gmail.com

Hi Krishsenthilraj, you can user Enterprise library provided by microsoft. and second option is to handle and exception and write a logger for it and then redirect to one common page which will display an user friendly error messsage to the user. In case of any futher help let me know

Rahul Goel Microsoft Cerfied Solution Developer .Net Contact me at : rahul.g2510@gmail.com