BTW You are not using a named instance, are you?

I don't agree with the 16 bit theory. From your link it is suggested that sql will use Tabular Data Stream (TDS) 4.2 which is independent of the 16 bit...

I am shooting in the dark here but:

If you move the db to SQL Server 2000 and run

EXEC sp_dbcmptlevel 'yourdb', 65

are you able to connect?

if you are using the sa password on the registration of the server on EM right click on it, select edit registration properties and update sa password and also make sure...

Have a look at TEXTCOPY /?  on the binn directory it allows in/out of text/image fields

HTH

two issuses here:

1. Insert must specify field list to work correctly (This is considered a best Practice) Like: insert into tblname (fld2) select 1

2. Al long as you don't have...

If you refresh every day overwriting the end server you can:

1. Truncate all tables at destination

2. Put the Destination recovery mode in BULKLOGGED

3. Use bcp to pump data in

3. Change...

try DBCC SHOWCONTIG ('TableName')  WITH TABLERESULTS

Look at AverageRecordSize, MaximumRecordSize, MinimumRecordSize

Cheers!

Yep,

setup will prompt you for that!

yes  you can use

dbcc checkident ('TblName', RESEED, 200600000)

just keep in mind the limits on the maximum int value could be exceded I would recommend to use two digits instead...

sofiane,

N'  means you are going to use a unicode version of the string. Is usually required by nchar,nvarchar and ntext types. (btw sysname = nvarchar(128) )

the systax means: <semantical meaning,...

I think you have found the anwser to your own question. You have gone above the maximum capacity specifications for SS 2000.

Solution: Redesign

HTH

Ramesh,

The views on sql server are EXPANDED by default when creating the execution plan therefore using the correct indexes on the base tables (like

>>>For clarification you can index views but only the Enterprise, Developer, and Evaluation versons of SS2K support them.<<<

Allow me to differ

Indexed views are suported in the standard edition also and...

To Use This method the access to the table has to be allowed only through stored procedures, then on the sp you will check for the Lock.

Cheers,