SSCCommitted,

Thanks for the response. I was hoping to somehow identify the The connection info for for Data source in the config file same way we can identify the AppName and...

Hi,

Thanks for the response. I need the last record for the current page in the report not the total report.

Hard coding the no of records may not work since...

Thanks for the quick reply . It is a production server hence i cannot risk running the dbcc freeproccache.

However , the recompile should have taken care of that. I...

I think it is mostly the interviewers without much DBA experience who ask bookish , memory oreinted questions . Someone (current message thread)  commented about DBAs who work for years without...

I offered to answer orally but the interviewer insisted on writing it down on paper in front of him . It was relatively an easily question but the the thought in...

A related question to my original post . When the failover happens and the ownership is transferred to the 2nd node (active/passive cluster) , should'nt the sqlserver automatically find the...

Hi Hans ,

 Do u do the coding in the same language -: )

nunYoBusiness,

 Thanks a lot for taking time to explain. As of now , i think i have all the necessary pieces of backup...

Thank u all for your input. Sincerely appreciate it.I did read sp4 instructions prior to my post. My plan was  to find the shortest possible path for sp4 install and possible...