... I should add that I do NOT need these uncommitted records. OK to lose them.

I dont have enough disk space to backup the log locally but I can backup...

Thank you, Arnold. I will check out your article.

Actuall, I did just that - added a Cleanup task to purge the old files. Shouldn't be necessary though because the backup...

Thanks bledu.

Wow, what a change from 2000's DTS.

Thanks for an enlightening article, Joe.

You state: "Running any form of query on a heap will force a full scan of the table and could take a considerable amount of...

Thanks Joshua T. That's a very good procedure. I'll experiment with that at the office.

"If this is executed while a deadlock if occuring.."

But I never know about a deadlock until...

Thank you Amit.

I use S-S 2000.

I ran your entire set of code, but nothing was written to the ouput table. Is your step for 2005 or 2000?

But on the subject...

Jeff,

You can find the id in msdb's sysdtspackages table. 

yep hombrew01. It can sometimes revert back to the original owner. That's been very frustrating for me. I will remember your tip.

Thanks, John

skeane, Thank you for replying.

Turns out, you are correct. This isn't a font issue at all.

I had to visit the user's PC and change the File Association for .TXT files...

Thanks Brendan.

"Instead of Visual Basic .NET 2003, check out the Express Editions of Visual Studio 2005. They'll be much cheaper, and possibly have more features. The only thing is that...

Brendan and David, thanks very much for taking the time to help this DBA out.

OK, I need to make sure I'm making the correct assumptions:

(We don't even have any Visual...

I encountered this message just today as I was testing permissions for one of our developers.

********************************************

The solution is to grant the user db_datareader permissions within the msdb database.

Then the user/programmer...

also...

Try running DBCC SHOWCONTIG .....  WITH ALL_INDEXES 

If you didn't do that already, this will show the frag level for all indexes in the table

The index you listed looks good...

Gordon,

You may need to create a local user (yourself) on the Novell server. Then try the xp_cmdshell again.

If that fails, create a mapped drive On SQL Server machine, pointing to...

Danny,

I had this situation recently, using Snapshot replication in SQl Server 2000.

After much head-scratching, the problem turned out to be NOT ENOUGH DISK SPACE on the server that was the...