Sounds a little odd.  Maybe you can post the backup script. What does EM show as "Space Available" ?

It would be interesting to restore your backup & see what you...

Your kill 54 probably needed 2+ hours to undo whatever it had done. Once you killed it, you can run "kill 54" again, and it will give you a progress...

It's not quite as simple as just changing the recovery model to SIMPLE to avoid doing backups. "FULL" recovery allows you to recover lost or corrupted data from a point...

I wrote a similar utility, and I use it to compare databases,  for example to check for differences between TEST & PROD. Just modify the above to output to tables, then compare...

I do something similar. See:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=225752

You could try importing the text file into MS Excel first. Then you can tell Excel where to create the columns to break up the data. Then, import the Excel...

Something like this  ??

select g.name,  d.name as 'IndexName', e.indid as 'IndexID', e.keyno as 'KeyFldSeq', f.name as 'FieldName'   

from  TI..sysindexes d

join TI..sysindexkeys e on d.id = e.id and d.indid =...

Sorry to nitpick, but if it's a SQL2000, question, why post it in the SQL 2005 forum ?  It just adds to the confusion ?

Just wondering .....   why not upgrade to SQL 2000 ??

If it was in full recovery mode, you could run out & buy Lumigent or something similar and undo all the statements.  I'm not sure how a DROP TABLE is...

I've looked and have not found a way to copy from 1 DTS to another.  Could have used it a few times.

We bought Idera's Diagnostic Manager recently.  Satisfied so far, and looking forward to some enhancements coming out.

They all offer free trials, so load them on a test server and give...

For more detail, create an output file for each step in the job.

Open the job -> Steps -> Edit -> Advanced

Then go down to "Output file" and specify a file...

I'm not sure of your question ....  Are you trying to find them in Enterprise Manager ?  I only have pull subscriptions, and they are on the subscribing server. In...

Easy

Right click the publication and generate sql script to delete the publication. Paste the portion of the script that has "exec sp_drop article"  for the article(s) you want to remove...