I have been for the last month. Send me an email or post to this forum and I'll answer any questions as best as I can.

Terry

select o.name, i.name from sysindexes i, sysobjects o where i.name

like '_WA_Sys%' and o.id = i.id

I didn't think it's that complex. However, it doesn't seem to work based on my...

Has anyone applied this yet? If so, any adverse affect to processing?

Terry

Anyone find any good training material that is worth the cost??

Terry

Richard,

thanks for the reply. We already brought someone in to do the analysis for us.

Terry

Go to all forums->security. There is a topic on EM security.

Terry

Forget this one folks. I should have searched before posting (found one under security, who would have thought it!!)

Terry

Please disregard the last message. Evidently, you need to shut down EM after setting the database to single user mode, then all works fine.

Terry

I set the db to single-user via EM. When I run the DBCC script, I receive an error stating 'Database 'JDEProduction' is already open and can only have one user...

What about dropping/recreating the indexes in question? Evidently this started happening on one of the production datsbases a couple of months ago and they finally asked me to step over...

I started that as soon as I got in this mornig. It returned the following: CHECKDB found 3 allocation errors and 17 consistency errors in database 'JDE_PRODUCTION', as well as...

I feel like a fool. Thanks for the insight.

Terry

Ahhhh..I thought about this all night and came to the same conclusion Antares. We did apply a hotfix on the server a couple of months ago. Once I removed it,...

I've re-downloaded twice and tried re-installing more than a few times. The @@version doesn't change, staying at 8.00.534. I found a few things on the KB, such as stopping IIS...

I had this same problem 2 days ago. I run SQL 2000 sp3. When attempting to restore a production backup to a test database, I didn't have enough room for...