I've never dealt with image data types, but assuming they are stored similarly to "normal" data, you would reindex the table to reorganize it.  If you have a clustered index...

I've seen taskpad throw errors from time to time.  Maybe thats what has happened to you.  Try shutting down Enterprise Manager, and restarting.

Steve

I'm not sure this will help, but you might try

DBCC CHECKTABLE(syslogs)

This is supposed to update the space used by the transaction log.

I remember being faced with the situation you...

Well, here's one way to do it.....

declare

 @string char(20),

 @input varchar(20),

 @len int

set @input = 'example'

set @string = ' '

set @len = len(@input)

select @string = reverse(stuff(@string, 1, @len, reverse(@input)))

select @string

Steve

By using BACKUP LOG ...WITH TRUNCATE ONLY, you are defeating the purpose of the full recovery model.  If you really don't need transaction log backups, consider changing to the simple...

Here's Microsoft's recommended procedure... its ugly...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

Steve

heber's example is really cool, but its important to realize that the counter is not a physical row number.  Frank's right, storage order in a MSSQL table is completely arbitrary,...

From BOL, the syntax for DBCC SHRINKFILE is as follows:

USE UserDB

GO

DBCC SHRINKFILE (DataFil1, 7)

GO

where

UserDB is the name of the database

DataFil1 is the logical name of the file you wish to...

We were having the same issue in SQL 2000.  The resolution was to apply the latest service pack.  

It is a KNOWN problem with both 2K AND 7.0.

MS Knowledge Base...

Enterprise manager uses the rowcount from sysindexes, which is only updated when statistics are updated, not necessarily whenever an insert/delete occurs.  For this reason, you should never rely on the...

Alter database with remove file is what I tried.  The response was that the primary file cannot be removed.

Kenneth,

Thanks.  This process was started months ago.  The server was 7.0.  I could never get rid of the extra file, so finally I quit worrying about it.  Now, we are...

Alamir,

Yes, that's the idea.  Make a full backup, then you can restore it wherever you like.

You got it!  Use the with move option.

Use restore filelistonly to get the logical filenames (pubs_data and pubs_log)

   RESTORE FILELISTONLY

    FROM DISK = 'X:\SQL_Backups\PUBS_special.bkp'

Then just plug the appropriate stuff in...

When you generate the script, the tsql commands that are in the job BECOME a literal which is enclosed in single quotes.  If the commands CONTAIN literals enclosed in single...