Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Current date is shown after query run

Posted on 2008-10-30
15
Medium Priority
?
153 Views
Last Modified: 2011-10-19
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.

0
Comment
Question by:Mehram
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 3
15 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22839622
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

0
 

Author Comment

by:Mehram
ID: 22839813

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.
0
 

Author Comment

by:Mehram
ID: 22839830
It seems that I have left

select getdate() somewhere, because the problem is removed right now.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 60

Expert Comment

by:chapmandew
ID: 22839873
Yeah, you probably just had a select getdate() or a print getdate() in there.
0
 

Author Comment

by:Mehram
ID: 22840139
No.

I executed this

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

mateen.bmp
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 1200 total points
ID: 22840159
Is there a trigger on the Count table that does a select getdate()?
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 800 total points
ID: 22840193
please check for a trigger for table your inserted into.
0
 

Author Comment

by:Mehram
ID: 22840330
You are absolutely right.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22840333
thought it might be....
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22840387
Hmmm...that doesn't seem right to do that.  :(
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22840418
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
0
 

Author Comment

by:Mehram
ID: 22847793
OK. Please re open and distribute the points 50/50.
0
 

Author Closing Comment

by:Mehram
ID: 31511600
It was my mistake.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question