|
Home > Archive > MS Access project with SQL Server > June 2005 > SQL Server 2005 differences....
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005 differences....
|
|
|
| Hi
I have some C++ code which creates a database fine under SQL Server 2000 but
when I attempt to create the same database under SQL Server 2005 Beta 2 I
get an error "Incorrect syntax near UPDLOCK". The line in the code which
this relates to includes a table hint in the SQL statement - FROM myTable
(ROWLOCK UPDLOCK). Is this table hint handled differently in SQL 2005 and if
so what is the correct syntax?
Any help would be much appreciated.
Many Thanks
Paul
| |
| Sophie Guo [MSFT] 2005-06-08, 3:24 am |
| Hello,
For the question regarding SQL server 2005, please post at the following
newsgroup:
Welcome to the Microsoft SQL Server 2005 Beta 2 Newsgroups
<http://communities.microsoft.com/ne...sqlserver2005&s
lcid=us>
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================
====================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| Vadim Rapp 2005-06-13, 8:24 pm |
| MG> I have some C++ code which creates a database fine under SQL Server
MG> 2000 but when I attempt to create the same database under SQL Server
MG> 2005 Beta 2 I get an error "Incorrect syntax near UPDLOCK". The line in
MG> the code which this relates to includes a table hint in the SQL
MG> statement - FROM myTable (ROWLOCK UPDLOCK). Is this table hint handled
MG> differently in SQL 2005 and if so what is the correct syntax?
if you try it in management studio (June build), the error message returned
by sql server is pretty descriptive:
"Incorrect syntax near 'UPDLOCK'. If this is intended as a part of a table
hint, A WITH keyword and parenthesis are now required. See SQL Server Books
Online for proper syntax."
It even says - _now_ required, as you can see.
Vadim
|
|
|
|
|