November 16, 2005 at 4:38 pm
what do commands that start with xp like xp_cmdsheell for? what are the stored procedures that start with dt_
i read for security it is good idea to disable the sql agent, but don;lt you need the agent to be running for anyjob that is scheduled. if the agent is disabled, no jobs will run, right?
is it good practice to diable the sql mail since it is not often used, this brings up the question, if I configure an operator and an alert for operator to be sent to his email. how do I configure sql server to be able to use our companies email system?
how or where to block ports. if i change the default port in sql server tcp/ip network properties to say 62314, does this block port tcp 1433 or not, how/where to block thse ports and specify only outbound traffic for that matter, in sql server, in lan connection tcp/ip properties, where
November 16, 2005 at 7:22 pm
Stored procedures that begin with xp are extended stored procedures e.g. dynamic-link libraries (DLLs) that SQL Server can dynamically load and execute.
Stored procedures that begin with dt_ are either for Enterprise Manage Database Diagrams or integration with Visual Source Safe.
"if the agent is disabled, no jobs will run, right?"
Correct.
"Is it good practice to diable the sql mail since it is not often used, this brings up the question, if I configure an operator and an alert for operator to be sent to his email. how do I configure sql server to be able to use our companies email system?"
I you do not configure a mail client under the account used to run SQL Server, then alert emails cannot be sent including to operators.
As mail is vunerable to the spreading of detrimental programs such as viruses, trojans or spy-ware, talk to your Exchange adminstrators about setting up this Exchange mail account so that it can send mail but cannot receive mail. This is done with the Exchange "Inbound Recipient Filtering". Also, to begin, you should check the account inbox on a regular basis (weekly ) to insure that no messages are in the inbox.
Note that the Exchange Server and the SQL Server must be in the same Domain.
SQL = Scarcely Qualifies as a Language
November 16, 2005 at 9:05 pm
awesome answers, thank you very much for your expertise, time and effort to respond!!!!
Adam
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply