Hi SSC Veteran,

Thx for your suggestions.

Thanks

Prakash

Hi Gail Shaw,

Thanks for your inputs.

Cheers

Prakash

Hi Gail Shaw,

in the sysprocesses system table i won't get full text of sql statemets currntly running. i want full text of sql statements so any method to get those...

thx Gail Shaw for u r reply.

i will concentrate on optimization. apart from index lookup where i need to concentrate to optimize the server to improve performance.

Thanks

Prakash

thx mike for your reply,

i do agree with your points. but my frontend is not critical like banking application where inconsistency effcts adversely.

since i am new to sql server u...

sure mistake won't repeat next time.

thanks

prakash