asked on

Current date is shown after query run

SQL Server 2005

In management studion, current date is being shown after query is run. Previousl it used to show number of rows affected. Probably I have changed some setting. What did I change. How to resolve the issue.

Guy Hengel [angelIII / a3]

can you show what you get exactly?

I only know about this kind of output:

SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 1 ms.
SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 1 ms.

Open in new window

Mehram

ASKER

There are two tab.

1. Result
2. Message

I am updating a table.
16 rows updated.

The query shows current date in result pane. When I click message tab, I can see 16 rows updated.

The result tab should not have been shown.

Mehram

ASKER

It seems that I have left

select getdate() somewhere, because the problem is removed right now.

chapmandew

Yeah, you probably just had a select getdate() or a print getdate() in there.

Mehram

ASKER

No.

I executed this

Insert count (count_code, count_name,active_tag)
values ('0875MLT','08.75/s Multi','Y')

mateen.bmp

ASKER CERTIFIED SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mehram

ASKER

You are absolutely right.

chapmandew

thought it might be....

chapmandew

Hmmm...that doesn't seem right to do that. :(

Guy Hengel [angelIII / a3]

unless you disagree that chapmandew posted the same information 4 minutes before me, I suggest that this question get's reopened for at least a points split

angel eyes

Mehram

ASKER

OK. Please re open and distribute the points 50/50.

Mehram

ASKER

It was my mistake.