473,396 Members | 1,783 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft sql server > questions > compare lock setting in sql srv 2000 and 2005

Join Bytes to post your question to a community of 473,396 software developers and data experts.

compare lock setting in sql srv 2000 and 2005

Hi All,
I am new with SQL server, current my company is running SQL Server 2000 and will move the database to SQL 2005. Once I move the database over to SQL Server 2005, is there a way for me to compare the setting of the locking mechanism, such as optimistic and pessimistic, I want to make sure they will be identical. Or is it all in the coding in the app itself. I've been reading what I can find but haven't came accross any visual settings yet.

Thanks all for any help/direction in advance.

tat
Aug 1 '08 #1
1 1260
balame2004
142 100+
SQL 2005 supports all the features that are existing in 2000 including locking. Only the new features are applied in 2005. These changes won't affect already existing features what you are using in 2000 and migration would affect nothing.

You carry on.
Aug 8 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
Database Compare Application help needed
by: Stephen | last post by:
I have to write a .Net application which can compare SQL Databases including things like: - DB structure, PK's, FK's, indexes and types of indexes i.e. should be able to detect if the same index...
.NET Framework
3
Script to lock down a regular user?
by: John Dalberg | last post by:
I don't like the fact that any user I create has access to system tables in the Master databases and the ability to issue 'sp_who' plus God knows what other system stored procs. Is there a white...
Microsoft SQL Server
1
Lock Situation with a special Sql-Statement
by: Michael Welp | last post by:
Hi, I have a problem with a special sql-statement. Perhaps somebody could help me or explain the behaviour of the DB2. My configuration : IBM DB2 V8.1.5 / Windows 2000 Server The...
DB2 Database
7
How to compare two Objects....
by: Prabhudhas Peter | last post by:
I have two object instances of a same class... and i assigned values in both object instances (or the values can be taken from databse and assigned to the members of the objects)... Now i want to...
Visual Basic .NET
8
Record lock timeout with webservices
by: Komandur Kannan | last post by:
We have a smart device application running on handhelds(Symbol MC9000G). The backend is Oracle and a middle tier web services development done in Vb.net. We use pessimistic Locking due to...
.NET Framework
1
Lock table problem
by: Sandy | last post by:
Hi I want to lock a table using JDBC as I want to perform some query's (read and write) in exclusive mode. Different threads will be executing the same code simultaneously. I am using the...
Microsoft SQL Server
94
When is "volatile" used instead of "lock" ?
by: Samuel R. Neff | last post by:
When is it appropriate to use "volatile" keyword? The docs simply state: " The volatile modifier is usually used for a field that is accessed by multiple threads without using the lock...
C# / C Sharp
2
Windows 2003 SP1 won't let me set the lock pages in memoryoption...it says I need Sp2.
by: Sanctus | last post by:
Is there a way around this? I have a SQL 2005 with 8 GB of memory that I want to set AWE on. But the local security policy won't let me, it says: This setting is not comaptiple with computers...
Microsoft SQL Server
4
Compare SqlExpress with SQL Server 2005
by: Tony Johansson | last post by:
Hello! Can anybody tell me what the main differences is between SqlExpress and SQL Server 2005. Or a URL where this information can be found. //Tony
C# / C Sharp
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!