Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-27 : 10:08:44
|
| shankar writes "Hello Team Members,FIRST PROBLEM:I have a problem while working with a DTS Package, I am creating aautomated sending mails package which will completely based on myspecified query.Say my query is as select taskid,login,email,description,details from xyz;Here, what i need is that for every login or email the correspondingdetails are to be pumped to the respective email ids.I had tried for a long time, what i am able to retreive is that either afirst column value or last column value.SECOND PROBLEM:Another problem is that I want to restrict the connection to my SQLServer system from any external IP address.For example, I have a system with SQL SERVER 2000 on Windows 2000 Server. If I wantto given an access to my superior who he is accesssing from singapore orUS. I want to allow only that IP address that is where he use the systemfor regular access. If that IP address is not matching with thespecified address. I would like to bounce the request.Finally the system should be accessible only to my developers(local) andto my superior(external).How do I configure this process on my server.If anybody can help me out regarding this. I would be grateful to them.Thanks in advance.shankar a.b." |
|
|
|
|
|
Help me UUUUUrgent