Thank to everybody,

at this point I have useful information to check the server.

Later I 'll give you some feedback.

Thank to everybody,

the fix from Microsoft is for:

If Address Windowing Extentions (AWE) support is enabled, a single instance of SQL Server 2000 can only use a maximum of 50 percent...

OS is Windows Server 2003 Enterprise Edition with SP1.

RAM is configured dinamically, not fixed (Max and Min).

Thank everybody

about AWE :I was thinking same thing AWE and /PAE enabled or not, so I have to check.

Intersting the code that I will be using later.

Thank

Hello,

specify the new record on DNS (or HOST file), otherwise SQL server cannot see the other one.

To see if SQL server sees the other one is to try to register,...

Hello,

If ypu do not see the server name running @@servername, you should restart SQL service.

Then it should be OK.

The problem is on internally and

SQL SERVER 2000 SP4.

Sorry it should be on SQL 2000 section

Hello,

thank everybody for your contribution.

I have seen the large code to rebuild a col in the same place. (I have found out that SQL drop and re-create the same table observing it by...

Hello,

I am using a Database not built up by me, and where an application runs on it that I have not built up (some SELECT * ....I do not know),...

Thank

for your contribution

I have found out a strange behaviour, on sql server 2005 inserting timestamp on binary(8) data is correct, on SQL server 2000 the values has zeros at the end.

Hi tried to load data into a binary field, but values terminates with some 0 "zeros".

How can I delete this "zeros" into the field or prevent this.

thank

and how to insert timestamp data into binary field. With right conversion

Thank

Hello,

Is it possible to alter a timestamp column to binary(8)?, because doing it by TSQL is not possible, but I am able to alter the column by Enterprise Manager

Thank

Thank to all,

I have already thought about changing datatype to binary(8) but at the moment the column should maintain the same datatype.