Wow...brilliant...!!

Thanks for your time and help..!!

This is the best part of the SQL Server community..!!

Thanks again!!!

Thanks Craig..Let me try that.

Jason,

Thanks for your response.

I tried many times and have failed to convince the management...:-(

Thanks!

Thank you. I have added a trigger for the same.

Hi Thomas,

Thanks for your reply.

If it is a DNS issue, do you think it would work well after a restart..?

Thanks!

Siva.

Hi,

Thanks for your reply.

There was no other error message in the log file.

Thanks!

Siva.

Hi,

Thanks for your response. I think the same too. Not sure if you have faced a similar situation before..

Regards,

Siva.

Thanks Jason...Let me do some research

Hi Jason,

Thanks for your reply.

I am able to make remote connections using SSMS.

Only the JDBC connectivity is giving issues..

Thanks!

Siva.

Thanks David...

Thanks Bob...

I was thinking that it is not necessary to mention the port name for named instance...SQL Server Browser service would take care of it internally..

Is this correct..?

this is great...exactly what I wanted..thanks so much..

Let me understand your code...if I have any questions, I will ask you.

Thanks so much again!!!

-Siva.

no..Not interview question...business question.

Here is the sample data.

CREATE TABLE T1 (CR_DATE DATETIME, CNT INT)

INSERT INTO T1 VALUES( '01/01/2012 08:30.200' ,1)

INSERT INTO T1 VALUES( '01/30/2012 09:30.200' ,1)

INSERT INTO T1 VALUES( '02/05/2012 10:30.200' ,1)

INSERT INTO...

Hi,

Thanks for your reply..

I just got this question...and have started googling...no solutions yet..

But I need to solve it in ASAP.. 🙂

Thanks!

Siva.