| Author |
Messages |
|
Timo
 |
| 08/29/2004 12:46 PM |
 Quote
 Reply
 Alert
|
| Followed the checklist of SQL Server Security -book and disabled the SQL Mail by DROPping some stored procedures. However there seems to be a case where I'm gonna need it, is there a way to re-enable it ? |
|
|
|
|
Chip Andrews
|
| 09/01/2004 7:56 AM |
Quote
Reply
Alert
|
| Absolutely, as a user in the System Administrator role excute the following:
USE master
EXEC sp_addextendedproc xp_startmail, 'sqlmap70.dll'
You can get the full listing of procs to DLLs by using the following query on a base SQL Server install:
Use master
Select sysobjects.name, text
From sysobjects, syscomments
Where xtype = 'X'
AND sysobjects.id = syscomments.id
Order by name |
|
|
|
|
|