Yes. I confirm it in SQL 2000.

I would like to say, there is no issue in selecting columns as compound indexes except some special data types, such as text and image.

But the number of total combined...

How about these commands? May them help.

sp_helpuser

sp_helprotect NULL, 'userName'--List permissions for specific user

sp_helprotect @name = 'objName'--List user names for a specific object

sp_helprotect NULL, NULL, NULL, OS-- list permissions for...

To update anything on a system table, we need to run

sp_configure 'allow updates', 1

RECONFIGURE WITH OVERRIDE

After completion, we need to run

sp_configure 'allow updates', 0

RECONFIGURE WITH OVERRIDE

May it help.

Change the status of your database, SUNDB, then re-apply your service pack.

Did you check the installation logs?

The following files, found on your server, can help provide valuable error messages if your SQL Server installation fails:

sqlstp.log (located in your \Windows or \WinNT...

First of all, we need to understand whether or not we should have disk defragmentation. If it is a standalone server configuration, I mean your server does not use SAN...

Here is my cent.

The number of threads are determined by the setting of your SQL Server. It is not a constant. It depends on the loading on the SQL Server....

Replace your VAL function by CSNG, then use FORMAT function.

May it help.

If it happens again, you may run

sp_who2 active

to check what process is biting the memory.

You may try the following DOS command. But you have to make them workable on a remote server.

at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\stop.bat"

at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\start.bat"

Where stop.bat

net start mssqlserver

start.bat

net stop mssqlserver

Did you check whether or not the account you use has permissions to view these objects in DB2?

Microsoft claimed that the memory leak in linked servers is fixed in SP4.

http://support.microsoft.com/kb/919165

No. SQL Server 2000 does not have the concept of delegation itself.

The reason why we should register a server from another is to test the connection before configuration.