I followed the advice of someone else on this site and set up an alert to backup the transaction log if it gets to more than 85% used. It seems...

Also look in the SQLServer log to see if there are any memory error messages. It can be caused by one query that needs a lot of contiguous memory.

The...

I have just send an attachment from a DTS Sendmail task (in MSSQL 2000) using MS Outlook 2002 (on windows XP).

In the sent items folder it shows the attachment with...

When you send an attachment in an email it is converted to encoded (encrypted really) text that is added to the bottom of the email. When it arrives on another...

You sort of hint that you are creating a new archive database and it doesn't already have records in. In which case another idea might be to restore a backup of your main database...

MDAC is just a set of *.dll files that live in the windows\system32 folder. These are the program libraries for ADO, ADOX, JSO, etc. When you install a later version of MDAC it...

Not sure if I understand exactly what you are doing but it sounds like you are doing a one-off update of an existing table, in which case you need something...

Make sure your archive database is large enough for the new records, or make sure it is growing in large chunks. Lots of little growths will slow down the copy....

Check in the SQL server error log for memory errors similar to "not enough contiguous memory". I can't remember the exact message now.

Once you get this message the query runs...

In Administration Tools, Service manager, have you tried starting the 'Messenger' service (make it automatic if currently manual). If it doesn't start the reason should be in the Event Viewer.

If...

The fact that you are using a different connection means that it is outside the transaction. Once you update a table using a transaction, SQLserver seems to cause all SELECTS from other...

I am just guessing here as I haven't had this problem. But, you could try scripting the delete of the publications and do it step by step to see if...

In enterprise manager:

go to Management - current Activity- Processes Info

then right click on the process you want to get rid of and select kill Process.

Peter

When you tried to drop the database, you say the message was that it is 'in use'. You aren't doning anything silly like leaving Query Analyser linked to the database,...

I restore my last backup onto a warm start server and use the following SQL to find the path of the last full backup file. Because I am restoring onto...