| Author |
Topic |
|
wotrac
Yak Posting Veteran
98 Posts |
 Posted - 2003-04-01 : 12:55:42
|
| We connect to our clients databases using Enterprise manager in SQL 2000.To do this we generate a new server registration which enables us to work, behind the scenes on their data.Problem!!! When the new server has been registred, our connection causes the two instances of SQL to constantly (talk to each other) even when there is no work taking place across our connection.If we neglect to de-register the additional server, our ISDN line will constantly dial up the remote server.Does anyone know of a way to avoid this, or possibly send an alert to remind someone of the situation.Apart from the obvious, which is to disconnect.Any ideas would be appreciated.Paul |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-01 : 13:37:09
|
| What do you mean talk to each other? Do they run sql statements or are they just sending and receiving network packets?I have about 40 servers registered on my machine. These servers do not communicate (SQL statements) with each other unless I tell them to do so.Tara |
 |
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2003-04-01 : 13:42:23
|
| No there are no SQL statements being run, so I assume theymust be sending and receivingnetwork packets. Or is it something to do with polling? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-01 : 13:47:45
|
| Are you sure that the two servers are talking to each other or is just that your machine is talking to each of the servers? If you are sure, then how is it that you know that they are talking to each other? Where are you viewing this information?Tara |
|
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2003-04-01 : 13:56:42
|
| I am making the assumption, because our ISDN line is dialling up the remote server at regular intervals, based on our telephone bill.But apart from the fact that it is registered in Enterprise Manager there are no other operations being carried out. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-01 : 14:01:13
|
| Ah yes then, it is because of polling. To change this, just go to Tools..Options..General. Uncheck the option to poll the servers.Just so that you know, the servers aren't talking to each other. It was your machine that was talking to them.Tara |
|
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2003-04-01 : 14:03:19
|
| Great!!But if I disable polling will I lose any other facilities when I am running queries or other routines on the remote server.Paul |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-01 : 14:06:46
|
| No, you will not lose any capabilities. Polling is used to just check the state of the servers that you have registered. If you want to check it without the tool automatically checking it, then just refresh the screen. You should consider using Query Analyzer instead of Enterprise Manager to do your work. Enterprise Manager is a resource hog and also is pretty limited in what it can do. Invest some time in learning the T-SQL statements to do the work, it will actually speed you up quite a bit in the long run.Tara |
|
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2003-04-01 : 14:09:30
|
| ThanksApart from Books Online, would you have any other recommendationsfor learning T-SQLMany ThanksPaul |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-01 : 14:14:03
|
quote:
Apart from Books Online, would you have any other recommendationsfor learning T-SQL
Yes, have a look at the books that SQLTEAM.com recommends:[url]http://www.sqlteam.com/store.asp[/url]Tara |
|
|
|
|
Server Registation Problems