enumerate the list of MSDE instances

Hi All,
I want to enumerate the list of MSDE instances on LAN using VB6.I
cannot use SQLDMO or SMO library.
I am using NetServerEnum API but it displays only SQL servers and
default MSDE instance.
Is there any API or other means to get the list of named instance of
MSDE in VB6.
Please advice.
Nidhi Sharma
Thanks for your response!
SuperSockets Network Protocols were enabled during installation of
MSDE2000.
I am able to connect successfully using <Computer Name>/
<InstanceName>. But the problem is that i am unable to get the list of
MSDE instances on the LAN.It displays the default instance if present.
Could you guide me how to broadcast UDP on port 1434 in VB6?
Nidhi Sharma

Enterprise Manager html error

Normally in Enterprise Manager the right hand pane displays icoms for
Diagrams, Tables, Views, etc. when a particulat database is clicked on in the
left hand pane.
For one particulat database, and only one, Enterprise Manager attempts to
display an html page with various tabs but this errors when loading and
displays wthout any information on it.
Why is this database differnet - I can't find any setting wich controls this
display or indeed any reference in BOL, and can I change it?
The error pops up an alert box as follows:
A Runtime Error has occurred.
Do you wish to Debug?
Line: 306
Error: Unspecified error.
unknown exeption
Break
Res://C:\...\sqlmmc.rll/Tabs.html
szDB =
parent.window.objSQLNSContext.GetDisplayName(strCo ntextCookie)
strContextCookie = GetParameterX("SQLNSCookie");
szDB = undefined
strContextCookie = "00FA25200000000000000001"
The line is called from JScript global code.
So, secondly, what is the error and can I fix it?
Thanks
Grant Ord
Grant,
You need to click on the database and then on the View tab change to
something other than Taskpad. Then change to Taskpad. The details should now
be fine. It is a known bug I think.
Chris Wood
Alberta Department of Energy
CANADA
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB =
> parent.window.objSQLNSContext.GetDisplayName(strCo ntextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord
|||http://www.aspfaq.com/2293
http://www.aspfaq.com/
(Reverse address to reply.)
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB =
> parent.window.objSQLNSContext.GetDisplayName(strCo ntextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord

Enterprise Manager html error

Normally in Enterprise Manager the right hand pane displays icoms for
Diagrams, Tables, Views, etc. when a particulat database is clicked on in the
left hand pane.
For one particulat database, and only one, Enterprise Manager attempts to
display an html page with various tabs but this errors when loading and
displays wthout any information on it.
Why is this database differnet - I can't find any setting wich controls this
display or indeed any reference in BOL, and can I change it?
The error pops up an alert box as follows:
A Runtime Error has occurred.
Do you wish to Debug?
Line: 306
Error: Unspecified error.
unknown exeption
Break
Res://C:\...\sqlmmc.rll/Tabs.html
szDB = parent.window.objSQLNSContext.GetDisplayName(strContextCookie)
strContextCookie = GetParameterX("SQLNSCookie");
szDB = undefined
strContextCookie = "00FA25200000000000000001"
The line is called from JScript global code.
So, secondly, what is the error and can I fix it?
--
Thanks
Grant OrdGrant,
You need to click on the database and then on the View tab change to
something other than Taskpad. Then change to Taskpad. The details should now
be fine. It is a known bug I think.
Chris Wood
Alberta Department of Energy
CANADA
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB => parent.window.objSQLNSContext.GetDisplayName(strContextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord|||http://www.aspfaq.com/2293
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Grant Ord" <grant.ord@.nospam.nospam> wrote in message
news:1D78B191-9D4C-4834-957B-E07828400110@.microsoft.com...
> Normally in Enterprise Manager the right hand pane displays icoms for
> Diagrams, Tables, Views, etc. when a particulat database is clicked on in
the
> left hand pane.
> For one particulat database, and only one, Enterprise Manager attempts to
> display an html page with various tabs but this errors when loading and
> displays wthout any information on it.
> Why is this database differnet - I can't find any setting wich controls
this
> display or indeed any reference in BOL, and can I change it?
> The error pops up an alert box as follows:
> A Runtime Error has occurred.
> Do you wish to Debug?
> Line: 306
> Error: Unspecified error.
>
> unknown exeption
> Break
> Res://C:\...\sqlmmc.rll/Tabs.html
> szDB => parent.window.objSQLNSContext.GetDisplayName(strContextCookie)
> strContextCookie = GetParameterX("SQLNSCookie");
> szDB = undefined
> strContextCookie = "00FA25200000000000000001"
> The line is called from JScript global code.
> So, secondly, what is the error and can I fix it?
> --
> Thanks
> Grant Ord

Enterpirise Manager Help

I need to know what tables in a particular database have been updated. The
Enterpirise manager only displays the creation date and not when the table
was updated. If their any way of finding this out?..
Thanks
OK, I've just read that you cant do that so the problem I have is this;
I have a DB with around 80 tables which only 20-30 are used on a daily
basis. I created a snapshot of all tables so thats not a problem.
What I want to know is when my subscriber has new data (merge) will it
automaticly push that data (table) to my distributor/publisher or does it
have to be triggered.
I'm new to this so please be patient.
Many thanks
""confused"" wrote:

> I need to know what tables in a particular database have been updated. The
> Enterpirise manager only displays the creation date and not when the table
> was updated. If their any way of finding this out?..
>
> Thanks
|||When the subscriber changes the data at the subscriber, it gets recorded in
metadata tables. These tables are read by the merge agent which then applies
the changes to the publisher. IE the data only flows upstream when the merge
agent runs. If this is continuously, this'll be usually within a minute;
alternatively it might be set to run on a schedule - you have to look at the
job to see how it is set.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Paul,
Thanks for the reply.
Another question I have is why do I have hundreds of 'tsvw_xxxxx' and
'ctsv_xxx' views. Also 'sp_selxxxxx', 'sp_updxxxxx' and 'sp_insxxxx' in the
stored procedure area??. What purpose are these files or do I have to
delete them manually.
Many thanks
"Paul Ibison" wrote:

> When the subscriber changes the data at the subscriber, it gets recorded in
> metadata tables. These tables are read by the merge agent which then applies
> the changes to the publisher. IE the data only flows upstream when the merge
> agent runs. If this is continuously, this'll be usually within a minute;
> alternatively it might be set to run on a schedule - you have to look at the
> job to see how it is set.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||The stored procedures 'sp_selxxxxx', 'sp_updxxxxx' and 'sp_insxxxx' etc are
all used by the distribution agent in transactional replication. When an
update occurs on the publisher, this is replicated (by default) as a call to
execute the 'sp_updxxxxx' procedure on the subscriber. The views " tsvw_"
are used internally by the merge engine. When I'm removing replication
completely from a database and some procedures/views remain afterwards, I
delete them manually. Otherwise I'd recommend leaving them in place or
you'll have to examine each one carefully so as to not break the existing
setup.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .