471,893 Members | 1,438 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Does anyone know the difference in the locking behaviour between sql 2000 and sql 7?

I came to know that the locking behaviour of sql 7 and sql 2000 is
different when creating objects.So we can use select into with large
resultsets without causing server wide problems.Can anyone here please
let me know what exactly is different when we create objects in sql
2000 vs sql 7 for the system tables.

Thanks in anticipations.
Jul 20 '05 #1
0 1071

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

37 posts views Thread by Curt | last post: by
12 posts views Thread by Puvendran | last post: by
11 posts views Thread by hendershot | last post: by
3 posts views Thread by Sam Brunetti | last post: by
29 posts views Thread by Vol | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

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.