You can refer to http://www.sqldev.net/xp/xpsmtp.htm. This is really a very cool solution. I was having many SQL Mail related problems, but now I have got rid of that. for...

The maintenace plan that you have created, must have created jobs in sql agent. can you verify, by looking in to the properties->notification, if any operator has been selected.

What you can do is , run the SQL Server with domain account and give all the required rights on the folder on the file server to that domain account,...

Try starting the MSSQLServer and SQLAgentServices with the domain account and assign Local admin rights to that account on the box.

Log on to the server, with the account, you...

Can you try this query with MAXDOP(1) hint.

May be this will solve the problem

The simplest way is to make the history tables and add a trigger on the existing tables. Trigger should log the existing values in the history table. May be this...

Do not play with the system SP's. What you can do is :

Find the body of System Proc using sp_helptext 'spname', and then create one for you with different name.

Just a simple question:

1. Have you started SQL Server Agent before stopping the Mail Services?

2. Can you check the SQL ServerAgent Error Log messages when SQL Agent has started ?

instead of restarting the SQL Server for realeasing the memory try the following command

DBCC DROPCLEANBUFFERS

You can use the DBCC DROPCLEANBUFFERS console command to release all data pages from memory. It...

for extracting the error log file you can use script like following:

CREATE TABLE [dbo].[Errors] (

[vchMessage] [varchar] (400)  NULL ,

[ID] [int] NULL

) ON [PRIMARY]

GO

INSERT dba.dbo.Errors EXEC master..xp_readerrorlog

DELETE FROM...

I encountered the similar type of problems a couple of days back. The error was like unable to open EMSMDB.DLL . After investigation we came to know that the MS...

here are the steps for executing the DBCC SHRINKFILE:

1. find out what is the logical name of the file that you want to shrink. You can use SP_HELPFILE to find...

This generally happens due to the permission problems and you can use the following SP to reassign the right to user for executing the DTS:

sp_reassign_dtspackageowner [@name =] 'name',

[@id =] 'id',

[@newloginname...

SQL Server 2000 supports a new feature that allows users to insert a named transaction in the transaction log and allow recovery to that point, similar to point-in-time recovery as...

You design the member tables so that each table stores a horizontal slice of the original table based on a range of key values. The ranges are based on the...