Many times EM functionality doesn't work properly until the item affected is refreshed.  I would first try refreshing the table in question (right click and select refresh), then the database...

To defrag a table (data), you simply defrag (or rebuild) the clustered index.  If your table doesn't have a clustered index, you can still defrag it by creating a clustered...

However, you can use SQL 2000 Query Analyzer to query 6.5 databases.  Also, you can "open" a table using object browser by right clicking on it and selecting "open". 

Steve

Another option would be to break your delete into smaller batches with a "CHECKPOINT" between them. The checkpoint will initiate a log truncation and should help keep your log smaller.

Steve

Change the owner of the database to "SA".

Steve

You say that the mssqlserver service IS started, but you can't start the "instance".  The mssqlserver service IS the "instance".  If the service is running, SQL 7.0 is running.  You...

David, Thanks.  Having worked in a government installation, I know where he is coming from.  I don't remember specifics, but in sensitive data processing, when you delete a record, it...

Hey Antares686, did you try doing a reindex?

Steve

If you decide to go the route of replacing your secret data with "garbage data" before deleting the record, there is something else you must consider.  If your "garbage data" is much...

declare

 @Prefix varchar(10),

 @FirstName varchar(10),

 @MiddleName varchar(10),

 @LastName varchar(10),

 @Suffix varchar(10),

 @First_Group varchar(50),

 @Last_Group varchar(50),

 @FirstLastName varchar(100),

 @LastFirstName varchar(100)

set @Prefix = ''

set @FirstName = 'Jeff'

set @MiddleName = 'L'

set @LastName = 'Bagwell'

set @Suffix = 'Jr'

set @First_Group =

 rtrim(isnull(@Prefix,''))

 +...

There's nothing wrong with your backup command.  I copied it to my machine, changed the path and db to match my system, and executed it without a problem. 

If you're...

If I understand what you are trying to do, I would suggest backing up to the local machine, and then ftp or copy the backup files to the remote machines.

Steve

"name" sounds a little suspicious for a server name.  Are you sure that's right?

Check whether SQL Server Agent is running under the system account or a domain account:  In Enterprise...

Is this what you're looking for???

declare @char nvarchar(10)

set @char = '$10.00'

print @char

select @char = replace(@char, '$', nchar(163))

print @char

--Steve

Sorry, just saw your "no room on local drives" message.

UNC:

\\servername\c$\Directory\filename

where "c" = server's drive letter

Steve