This is INFORMATIONAL message added in Service Pack 4.

There might be some operation going on (which caused file to grow) which was cancelled.

If you have profiler for same time, you...

Did you try running DBCC CHECKDB for the database? This is to make sure there is no corruption in database.

Desc: Sample database file already exists in SQL instance data directory.

Make sure that you have cleaned up data folder.

I am bit confused here....

You did it by stored procedure sp_attach_db?

I researched on it and found that there is no parameter to specify owner using stored procedure sp_attach_db.

If you do it...

create table Test (Col1 varchar(500))

insert into Test values('0,0,0,1,0,0,0,0,1,0,0,1,1,1,0,0,0,1,0,1,1,1,1,1,1,1,1')

select * from Test where Col1 = '0,0,0,1,0,0,0,0,1,0,0,1,1,1,0,0,0,1,0,1,1,1,1,1,1,1,1'

It works for me.. is there anything else which you are having in where clause?

Perfect grambowk 

Appending code to grambowk 

CREATE TRIGGER member_role_delete ON [dbo].member_role

FOR DELETE AS

insert into tbl_audit

select 'member_role', deleted.role_no,...

Only possible way to restore database in few seconds is "detach and attach"

• Q274750 HOW TO: Configure Memory for More Than 2 GB in SQL Server, <http://support.microsoft.com/support/kb/articles/q274/7/50.asp>

• Q283037 Large Memory Support Is Available in Windows 2000, <http://support.microsoft.com/support/kb/articles/q283/0/37.asp>

• Q291988 A Description of...

That's wierd.

Did you choose owner properly while attaching database?

sp_changedbowner is the next option for you.

you are getting this from Query Analyzer?

Msg 50001 (Error Number) tells me that it is custom error. This is from some application?

http://support.microsoft.com/kb/314515/EN-US/

Frequently asked questions - SQL Server 2000 - Log shipping

You really need to put the profiler trace. SQL server will not do this by its own 🙂

SQL Server will not use more than 2.8 GB of physical RAM. Its limitation of process running on 32 Bit operating system.

/3GB is the option by which SQL can use...

That's interesting.

Nice to know the "root cause" of this

I saw this behaviour earlier, I changed the outlook default mail editor to Notepad and problem went off.

Please try changing outlook default mail editor and let me know the results.