You might want to start looking in sysobjects.

You can get table info from this:

select * from sysobjects where id = object_id(N'[dbo].[tablename]') and OBJECTPROPERTY(id, N'IsUserTable') = 1

Antares, thanks for writing back.

I had one trace table from a trace that was previously run. That's the one he could see in the list, but it did not...

I decided to include the field DatabaseID--that will let me see what I need.

Thanks

Great...all good ideas. I like the cubicle volleyball and candy search ideas. There's a developer here with a ton of candy in her cube, but it's all in...

Thanks so much for the ideas. I'll try them out.

Lisa

Think about your very first job--did you have to do a lot of data entry? I did and became quite adept at the number pad.

Some entry-level...

Antares,

Yuck! I loathe chain mail.

I hate people who send and forward frivolous, stupid mail...especially virus hoaxes that they take seriously.

They always start out:

"FW: WINDOWS VIRUS ALERT"

Which...

I found an article at support.microsoft.com that would probably be very helpful.

"Q1: Why did SQL Mail stop working after I upgraded to SQL Server 2000?

A1:SQL Server 2000 introduces significant...

I think it may be login related, too. I've had this happen on an NT4 box.

Can you shut down the service from the Services menu?

Next, check to see...

I guess that I had checked to drop and recreate all objects, but I only selected the stored procedures, thinking it would just affect them--although all of the tables were...

Thanks, but I have been very careful that I am not selecting to delete anything from the tables. It seems like there is some sort of bug.