SQL Server 2005 differences....

[Mr G]

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]]

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/newsgroups/default.asp?icp=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]

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