You can find more:

http://support.microsoft.com/default.aspx?scid=kb;en-us;870675

http://support.microsoft.com/default.aspx?scid=kb;en-us;311231

http://support.microsoft.com/default.aspx?scid=kb;en-us;281293

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

http://support.microsoft.com/default.aspx?scid=kb;en-us;321183

And finally how to bypass SQL Mail:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312839

Andy

When you are restoring the database, you are using the Options tab to configure where to create the files, right?

Normally I configure a server to default to the Log and...

Tape devices are as large as your budget. Today from 3GB to thousands of TB.

For the mid-priced SCSI device range from DAT 4GB to DLT 360GB tapes. There are other solutions with...

Ok lets explore this: we write to the tape, so If you forgot to load the tape, then we are not able to write (full stop). So no backup of...

My wish list for the optimum SQL Server HD configuration is 4 SCSI RAID controllers, the first 3 are separate RAID 1 arrays for OS, Swap and OS log files,...

You did verify that Outlook can still connect using the default profile, to the mail server when logged in as the SQL Server service and SQL Server Agent service accounts,...

Thanks govinn for the DDL, here is one way:

SET NOCOUNT ON

DECLARE @TempTable TABLE

(

patient  varchar(10),

datebegin datetime,

dateend  datetime

)

DECLARE @Results TABLE

(

patient  varchar(10),

datebegin datetime,

dateend  datetime

)

INSERT @TempTable

SELECT 'A', '1/1/05', '1/31/05' UNION

SELECT 'A', '4/1/05', '6/30/05' UNION

SELECT...

Add:

PRINT '|'+@mailto+'|'

Watch out for spaces, invalid email addresses, and orphaned ; characters

and

PRINT '|'+@cmd+'|'

To double check the values while debugging, looks like you are missing a 4th ' at...

Here is what I do: I create a restricted web server login that can SELECT from and INSERT into *Request tables (Password and Account), then insert the desired information into the...

Your Job script could set the database to single user, perform it's update and set the database back to normal mode. This would require that it could set single user and...

Please share the registry location for this setting, inquiring minds want to know...

Andy

Applications can use 'sa' only functions, like the one in SQLDMO to change a user's password using NULL as the original password parameter, the NULL parameter requires 'sa' any other permission or...

First of all, change your code as follows:

set @sql = 'Insert into #TableColumns

SELECT '''+@DB1 +''',

Change to:

set @sql = 'SELECT '''+@DB1 +''',

When you EXEC the dynamic...

Then I take it that you have verified that the files exist as described in your task, right? If so then verify that the account that the task runs under...

Error 5 is typically a permission issue, can be caused by a missing file, share, etc. I have also seen this when the account the task is running under does...