The error sounds like you still have an item in it that no longer exists in the table. Are you saying you want something that will remove for you? If...

To my knowledge not directly. You might want to check for a third party app that does this. Or if someone knows a way I would be interested myself.

"Don't roll...

Object Browser is not a part of SQL Server, it is a part of the Query Analyzer shipped with SQL 2000 and works fine with SQL 7 databases.

"Don't roll your...

Ok got this message today on a user PC and was able to troubleshoot directly. The message is "CoInitialize was not called", after some looking I found that sqlmmc.dll was...

As far as admin, then yes I do believe it must be. Domain admin actually is better. The biggest reason to do this is so that each server is able...

I have no problems with this on mine. What does the DTS package do exactly. If it is outputing to a file the data then you may need to allow...

Is this SQL 7 or 2K?

Try this,

BACKUP LOG [dbnamehere]

WITH TRUNCATE_ONLY

Then see (http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1) for a script to help force the log size down.

"Don't roll your eyes at me. I will tape...

In addition if the server is compromised you most likely will have the key to the encryption password available anyway, so they have no work to do, and all you...

Ok, not saying this is the answer but could be a possiblity. We have had problems with Novell client using IPX/SPX that causes wacking to a remote server to freeze...

SQL is far eaiser to deal with and better at admin and security as opposed to SQL, especially since tere is no mdw (workgroup file) that has to come into...

If you are talking about SQL2000 database files running on the same server, the answer is no not thru SQL 2000. You can only have an external process that stores...

If you are talking data datatype, for the most part yes, I believe there a few unsupported data types in Oracle 8.0 and later but do not have a list...

Are you using named instances to connect to the database? And is does the PC which is not having trouble hit the Novell system. If so are you using IPX/SPX...

Take a look here

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q298568

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

In addition if the Wan is extremly slow hitting a SQL database is much better in the you can utilize stored procedures and get users only the data they need....