10% Growth for mdf and ldf files of tempdb database is allocated. Maxsize is unlimited

When performance is said to be down number of users are deifinately high. But it is...

Thanks everyone for valuable information.

I am running following statements to truncate the log and database size

Dump Tran with no_log

DBCC Shrinkdatabse (' ')

Thanks for the reply. Since I am not very much familiar with SQL 6.5. Can you give me any idea as how to convert the instance to multi-user mode.

Thanks a ton. The information / script was really helpful.

We get this after running

SQL2000-KB884525-SP4-ia64-ENU.EXE

Hi,

Thanks for your reply. @@version returns the below results.

Microsoft SQL Server 2000 - 8.00.194 (Intel X86)

Aug 6 2000 00:57:48

Copyright (c) 1988-2000 Microsoft Corporation

Standard Edition on Windows...

Thanks for your reply. Is there anything that can be used for bulk updates?

Thanks for your help. I can create multiple Text columns in a table with Standard Edition and inserted approx. 33K chars. in each column.

There is possibility that multiple columns can contain more than 8K chars. Also we have standard edition. Will that be a constraint?  

There are certain fields in the database where detail information about an indiual or an organisation is stored. This may cross 10K length.

Thanks  for your reply. These are readonly queries. Recordsets opened with Client side cursors.

Thanks for your reply.It was all about concatenating the variable in Execute procedure of SQL server. After I got the concatenation right now it is working fine. Another thing I...

Thanks a ton for your reply. The option of using OPENROWSET is best suited fot my application.

Thanks a ton

Regards

Rohit