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 |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2006-09-21 : 05:29:20
|
| Hi!I must write any attempts of connection to SQL in table andi have to determine IP of all attempts.How can I do it? Thanks in advance? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-21 : 05:40:05
|
| Try start with using HOST_NAME() and see what that gives you.Peter LarssonHelsingborg, Sweden |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-21 : 07:50:46
|
if you have you sql server setup that way that people can attempt to directly connect to it... change the setup.only valid apps should be able to connect to it.Maybe you should explaing your scenario better.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
How to determine IP of a connection?