Before you do a complete rebuild, you might try the following-

Copy your data and transaction log files to a safe location (unless you think they are already safe).

Delete ALL SQL...

OK, whats REALLY amazing, is that in the single script file that I downloaded is:

Numeric to character functions for English, Spanish and Portugese

Numeric to character stored procedures for English, Spanish...

No problem!

I kept it because I thought it was cool.  I didn't know if I would ever have a use for it.  But if you can use it, its been...

Sure is! Thanks!

Steve

I would think you would need the database names and the names of the files that are associated with each database to do that.  You could have pulled that information...

I don't remember where I got this or who wrote it, or I would give due credit. Steve...

CREATE function NumbersWords(@s VARCHAR(50))

--English words for numbers

returns VARCHAR(1024)

as

BEGIN

DECLARE @a char(1),@b char(1),@c char(1),@i...

Assuming that the enterprise manager you have is

"SQL Server Enterprise Manager.MSC", you would create a new shortcut for mmc.exe, with a startup parameter for the Enterprise Manager msc file,...

Davidf,

Yes, that is the point I was attempting to make.  Because the disk space that the data occupied has not been released to the operating system, it is still as...

milzs,

I see where you are coming from.  My point is that since the record (deleted or not) is still in the database, no "object is released".  Its still held by the...

Check the security log in event viewer to see if you can identify where it is coming from.  There is a process somewhere that is trying to log in with...

You know, because we're talking about deleted records in an existing database, and the "deleted" records may/may not be completely deleted, those "deleted" records are still as safe as the existing...

You know, when I did that "sneaksy" reverse stuff, I was thinking, "there's got to be a better, more direct way to do this."  I was obviously in a character...

See if this will work for you...

declare

 @amt varchar(10),

 @fmt varchar(10),

 @flt float (2)

set @amt = '0000133041'

select @fmt = reverse(substring(reverse(@amt),1,2) + '.' +  substring(reverse(@amt),3,7))

select @fmt as 'varchar'

select @flt = cast(@fmt as float)

select...

You can't really "turn off" the transaction log.  Its an integral part of SQL Server.  You have two options for clearing the log on a regular basis.

1.  You can do...

Just found this post by David Burrows in another thread (Administration."Ghost Cleanup"? Configuration...)

Quote from David Burrows:

To confirm your observations, found this on TechNet