found two articles.  the first is the MS article I found.  THe problem described is not the same problem. but the behavior is the same.  The second is an atricle...

I was the original post.  If I remember correct this is a documented problem is Sql Server.  Stop and restart the SQL Server and the problem is corrected.

Thanks Philip, that is what I was thinking, just wanted another opinion.  I just chose 11 minute to stay away from human nature, people...

Has anyone figured this one out yet.  I'm having same problem. 

Trace flag is set

alert is enabled

I caused an error 1205 and did not receive the alert.

have you tried DBCC DROPCLEANBUFFERS.  Can't remember, but I think you need to a checkpoint just before because this command only clears the "clean" buffers.

just a note about db_datareader ...

db_datareader give a user permission to read any items

to block writes use db_denydatawriter which prevents users from writing to the database.

Be careful using access against SQL server:  If I remember correctly, even if you query a table in SQL server from access, in some cases access brings back all the rows...

Frank you da' man!!!  Thanks for the hard work.  (By the way, you give good answers, not just fluff!)

-- IF you can take the DB's offline you using SQL7+ you can also detach the DB and copy the file(s) to the new server.

It just saves you the backup...

Just curious -- can multiple users run this SP.  Your SP looks like it uses a perm table "SalesSummaryReport".  Could multiple users be loading the table at the same time.

If...

Hi -- Since you mentioned space issues.  Just wanted to let you know that there are compression options for backups.  I was running low an space because of the backups...

would it be possible to seperate the data into multiple tables. for example by each year/ quater, etc.  that would give you a couple of options.

1) create a view that...

should not need outlook running the background.

Try this:  Enterprise Mgr right click server.  then security tab.  Startup account.  is it system account or System account.  if system, then that account...

may help, not sure.  The problem may have something to do with SQL being unable to fnd the correct profile to use.  is sql running under a local or domain...

Sorry I cannot find any notes on how I corrected this problem.  At the time I found the document on MS support on why the mail is failing.

It may have...