Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brandonl
Yak Posting Veteran
58 Posts |
 Posted - 2002-08-13 : 11:31:53
|
| I have a SQL 7 SP3 server, that-no matter what account I am logged in as (even sa), if I run a query like such:SELECT TOP 1 field FROM tableIt gives a "Incorrect Syntax near '1'"Is this some setting that I can turn on or off? In enterprise manager the "Return Top" option is also grayed out. Any ideas?~BrandonL |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-13 : 11:33:20
|
| probably running in 6.5 compatability mode - did you upgrade a database?try sp_dbcmptlevel dbname==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 08/13/2002 11:35:18 |
 |
|
|
brandonl
Yak Posting Veteran
58 Posts |
Posted - 2002-08-13 : 11:41:42
|
quote:
probably running in 6.5 compatability mode - did you upgrade a database?try sp_dbcmptlevel dbname
Yes, it's in 6.5 comp. mode. Is that an install only option, or can I turn 6.5 comp. mode off?~BrandonL |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-13 : 11:45:36
|
| look at sp_dbcmptlevel in bolsp_dbcmptlevel dbname, 70==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-13 : 12:10:46
|
| And read what it says about the changes - especially the one about group by not ordering the results in v7.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
brandonl
Yak Posting Veteran
58 Posts |
Posted - 2002-08-13 : 13:03:11
|
quote:
look at sp_dbcmptlevel in bolsp_dbcmptlevel dbname, 70
running that worked. Thanks!~BrandonL |
|
|
|
|
|
|
Cannot "SELECT TOP # FROM..."