SQL Query Analyzer 1

[Mantle51]

Hello,
Brand new to SQL Server and I'm trying to run SELECT statements in Query Analyzer with the intended output on the bottom pane to be in grid format. Instead the message tab reads "The command(s) completed successfully.", while the grid tab is blank.

Thank for your help.

Mickey

 

[gmmastros]

What select statement are you trying to run?

-George

"the screen with the little boxes in the window." - Moron

 

[SQLBill]

Possible issues...
1. you parsed the query instead of running it.
2. the query is not a select.

If the query is a CREATE PROCEDURE with a SELECT statement, you will get The command(s) completed successfully statement.

-SQLBill

Posting advice: FAQ481-4875

 

[Mantle51]

Ahaaa, thank you SQL Bill...!

 

[SQLBill]

You are welcome and thank you for the star. What ended up being the issue? Were you parsing it or was it part of a CREATE PROCEDURE? If it was part of a CREATE PROCEDURE, then remember the procedure was created and exists.

-SQLBill

Posting advice: FAQ481-4875

 

[Mantle51]

It was part of a CREATE PROCEDURE for sure. Thanks again!