The next version of SQL Server will allow you to do that with a new isolation level called SNAPSHOT. As I can see in BOL (Yukon), this will make SQL...

Hello Robert,

Here is some doc about that subject (found in BOL):

DBCC {

...

SHRINKDB (database_name [, new_size[, 'MASTEROVERRIDE']])

...

}

---------------------------------------------

SHRINKDB (database_name [, new_size [, 'MASTEROVERRIDE']])

When specified with only the database_name parameter, DBCC SHRINKDB...

I am not sure exactly if it is waht you are asking for but look at this (you'll find more on this in BOL):

Setting a Backward Compatibility Level:

When running at...

Thank's David,

The server was not installed by me.

We frequently install SQL Server 7.0 on laptop and I don't remember the wizard offering me that choice...

Carl

Nobody is able to answer to that question:

On a SQL Server 7.0 what determines the value for the Locale ID?

There is almost nothing in BOL about that.

Carl

Don't Forget that we are on a SQL Server 7.0.

SERVERPROPERTY does not exists:

SELECT SERVERPROPERTY('collation')

Server: Msg 195, Level 15, State 10, Line 1

'SERVERPROPERTY' is not a recognized function name.

N.B. We used...

The information I have is the following:

=========================================

Snapshot Isolation Level allows users to access the last committed row using a transitionally consistent view of the database. This new isolation level provides...

I don't know exactly how DTS works but I know that on Oracle LONG datatype are restricted to one per table.

Instead of using LONG datatype Oracle strongly suggest to use...

We have had the same behavior when we moved from 6.5 to 7.0.

The main raison explaining the poor performance we were experienced on 7.0 was that we were not...