EnumAvailableSqlServers does not return version numbers correctly

Hi,
I have a machine that has just SQL2005 (as default instance with no instance
name.) I am trying to list all SQL 2005 server instances on the network usin
g
SmoApplication.EnumAvailableSqlServers( ) and trying to filter the servers
based on version information. This machine shows up in the list, but does no
t
have version information. I saw another post on Sql Server Programming
newgroup without any response. Is this a known bug in SMO? If it is, does
anyone know how I can list SQL2005 servers only on a network that has both
SQL2005 and SQL2000 servers?
Any help is geratly appreciated.SMO in its current implementation uses
SqlDataSourceEnumerator.GetDataSources under the cover (
http://msdn2.microsoft.com/en-us/li...
etdatasources(VS.80).aspx)
Can you try writing calling this instead and see if you get the version?
This can help us isolate the problem.
Thanks,
--
Ciprian Gerea
SDE, SqlServer
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raghu" <Raghu@.discussions.microsoft.com> wrote in message
news:7EB858DE-22E5-41B3-B46A-1D8229406630@.microsoft.com...
> Hi,
> I have a machine that has just SQL2005 (as default instance with no
> instance
> name.) I am trying to list all SQL 2005 server instances on the network
> using
> SmoApplication.EnumAvailableSqlServers( ) and trying to filter the servers
> based on version information. This machine shows up in the list, but does
> not
> have version information. I saw another post on Sql Server Programming
> newgroup without any response. Is this a known bug in SMO? If it is, does
> anyone know how I can list SQL2005 servers only on a network that has both
> SQL2005 and SQL2000 servers?
> Any help is geratly appreciated.

enterprise to standard

dear all,

if one has purchased enterprise edition of sql server, could he install the standard version instead of the enterprise one without violating software license?

regards

My suggestion would be to contact the vendor that you purchased the licenese through and check with them.

Thanks,
Sam Lester (MSFT)

enterprise to standard

dear all,

if one has purchased enterprise edition of sql server, could he install the standard version instead of the enterprise one without violating software license?

regards

My suggestion would be to contact the vendor that you purchased the licenese through and check with them.

Thanks,
Sam Lester (MSFT)

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!
Did you uninstall and reinstall the client tools? Did you apply SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!
|||
> I have two workstations with fresh reloaded sql2000(sp3a) client
> software and fresh reloaded MDAC(current version 2.8)
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Yes and Yes.
> I have two workstations(WIN2K SP4) with fresh re-loaded, re-installed,
re-booted sql2000(sp3a) client
> software and fresh re-loaded, re-installed, re-booted MDAC 2.8(current
version).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sql

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!|||
> I have two workstations with fresh reloaded sql2000(sp3a) client
> software and fresh reloaded MDAC(current version 2.8)
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Yes and Yes.
> I have two workstations(WIN2K SP4) with fresh re-loaded, re-installed,
re-booted sql2000(sp3a) client
> software and fresh re-loaded, re-installed, re-booted MDAC 2.8(current
version).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!

Enterprise Manager-like application

I wanted to build my own custom version of Enterprise Manager using vb.net.
Where can I get the icons/pictures that enterprise manager uses (eg the
icons used in the treeviews for database, table, user, stored procedure,
user-defined function etc)I wouldn't think that would be legal.
But you can always make your own.
<arch> wrote in message news:42f7ef77@.funnel.arach.net.au...
>I wanted to build my own custom version of Enterprise Manager using vb.net.
>Where can I get the icons/pictures that enterprise manager uses (eg the
>icons used in the treeviews for database, table, user, stored procedure,
>user-defined function etc)
>|||Shane,

>I wouldn't think that would be legal.
AFAIK is it in most countries illegal.
(Before somebody ask it, I don't know any country where it is legal).
Just my 2 eurocents
Cor|||Unless arch is planning on redistributing his custom app, I think that using
the icons on his own machine (very easy to create GIFs using a screen shot)
would come under fair use...
"Shane Story" <nospam@.nothanks.com> wrote in message
news:ehewDsHnFHA.1948@.TK2MSFTNGP12.phx.gbl...
>I wouldn't think that would be legal.
> But you can always make your own.
>
> <arch> wrote in message news:42f7ef77@.funnel.arach.net.au...
>|||You can go to download.com and find several shareware / freeware
applications for extracting icons from .exe and .dll files. Also worth
mentioning is that the sample applications that come with SQL Server include
a VB 6.0 project that uses DMO to create a simplistic Enterprise Manager
style application.
<arch> wrote in message news:42f7ef77@.funnel.arach.net.au...
>I wanted to build my own custom version of Enterprise Manager using vb.net.
>Where can I get the icons/pictures that enterprise manager uses (eg the
>icons used in the treeviews for database, table, user, stored procedure,
>user-defined function etc)
>|||Have you looked at the available alternatives?
http://www.aspfaq.com/show.asp?id=2442
At least one (myLittleAdmin) provides an API for further
customisations.
David Portas
SQL Server MVP
--sql

Enterprise Manager: The connection to SQL Server <server> has been broken.

All~
I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:
The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...
I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].
What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
...
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
...
Your help is greatly appreciated.
Richard
Check your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523
-Sue
On 31 Jul 2004 07:22:35 -0700, rkinnie01@.excite.com (Richard
K) wrote:

>All~
>I am currently running the most recent version of MSDE and using EM as
>a front end interface. In EM, I go to look at the databases I had
>previously created, but receive the message:
>The connection to SQL Server <server> has been broken. The connection
>to the SQL Server is broken. Do you want to try reconnection...
>I am unable to start SQL Agent, but I am not sure whether this is the
>cause. I am able to connect via the Query Analyzer facility fine. I
>get the following SQLDump [truncated].
>What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
>...
>**
>*
>* BEGIN STACK DUMP:
>* 07/31/04 09:59:24 spid 0
>*
>* Exception Address = 00000000
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000000
>...
>Your help is greatly appreciated.
>Richard

Enterprise Manager: The connection to SQL Server <server> has been broken.

All~
I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:
The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...
I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].
What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
...
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
...
Your help is greatly appreciated.
RichardCheck your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523
-Sue
On 31 Jul 2004 07:22:35 -0700, rkinnie01@.excite.com (Richard
K) wrote:

>All~
>I am currently running the most recent version of MSDE and using EM as
>a front end interface. In EM, I go to look at the databases I had
>previously created, but receive the message:
>The connection to SQL Server <server> has been broken. The connection
>to the SQL Server is broken. Do you want to try reconnection...
>I am unable to start SQL Agent, but I am not sure whether this is the
>cause. I am able to connect via the Query Analyzer facility fine. I
>get the following SQLDump [truncated].
>What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
>...
>**
>*
>* BEGIN STACK DUMP:
>* 07/31/04 09:59:24 spid 0
>*
>* Exception Address = 00000000
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000000
>...
>Your help is greatly appreciated.
>Richard

Enterprise Manager very slow on XP Pro

Hi,
I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
same version of SQL installed on W2K / P3. The Enterprise Manager seems to
run much slower on XP than on W2K. A simple click in the left pane (e.g. on
'databases') results in 20-30 second wait (the disk led is lit solid during
that time).
Could anyone please give me any suggestions as to what I should be looking
for on the XP machine?
Thanks,
Bogdan
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
to
> run much slower on XP than on W2K. A simple click in the left pane (e.g.
on
> 'databases') results in 20-30 second wait (the disk led is lit solid
during
> that time).
Do please check if your databases have the autoclose option turned on. This
is default for Personal edition, and it takes time to open all databases.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Also verify that you have no ODBC tracing turned on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message
news:u2kKHRKRFHA.3704@.TK2MSFTNGP12.phx.gbl...
> to
> on
> during
> Do please check if your databases have the autoclose option turned on. This
> is default for Personal edition, and it takes time to open all databases.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
|||Neither of the databases had auto-close enabled. The ODBC tracing was not
enabled (although I'm not using ODBC to connect to any of the databases and
I hope that Enterprise Manager does not use it either).
What seemed to work was SP3a. I applied it last night and things appear to
be 'normal' now.
Dejan, Tibor: thanks for your responses.
Bogdan
"Bogdan" <someone@.domain.com> wrote in message
news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
> to run much slower on XP than on W2K. A simple click in the left pane
> (e.g. on 'databases') results in 20-30 second wait (the disk led is lit
> solid during that time).
> Could anyone please give me any suggestions as to what I should be looking
> for on the XP machine?
> Thanks,
> Bogdan
>
|||> I hope that Enterprise Manager does not use it either).
Both EM and QA uses ODBC.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bogdan" <someone@.domain.com> wrote in message news:e3FUs4URFHA.3944@.TK2MSFTNGP10.phx.gbl...
> Neither of the databases had auto-close enabled. The ODBC tracing was not enabled (although I'm
> not using ODBC to connect to any of the databases and I hope that Enterprise Manager does not use
> it either).
> What seemed to work was SP3a. I applied it last night and things appear to be 'normal' now.
> Dejan, Tibor: thanks for your responses.
> Bogdan
>
> "Bogdan" <someone@.domain.com> wrote in message news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
>
|||Dejan Sarka wrote:
> Do please check if your databases have the autoclose option turned
> on. This is default for Personal edition, and it takes time to open
> all databases.
I've had a laptop that's been slow for months with QA and SQL EM and
it's been driving me crazy. Even pressing the Cancel button from the
Database properties in SQL EM caused undue database and disk activity.
Checked the databases, and sure enough, there was one user database that
mysteriously had Auto Close turned on. Probably turned it on for testing
and forgot to turn it off.
You fixed me. Thanks.
David Gugick
Imceda Software
www.imceda.com
|||If you want fast access to your database try SQL Admin Studio from
www.simego.com as this tool is just amazingly fast at connecting and
browsing SQL Server Databases.
"Bogdan" <someone@.domain.com> wrote in message
news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
> to run much slower on XP than on W2K. A simple click in the left pane
> (e.g. on 'databases') results in 20-30 second wait (the disk led is lit
> solid during that time).
> Could anyone please give me any suggestions as to what I should be looking
> for on the XP machine?
> Thanks,
> Bogdan
>
|||Another way that I've seen autoclose turned on is when
moving a database from MSDE to MSSQL.
MSDE, IIRC, defaults to autoclose on.
jg

Quote:

Originally posted by David Gugick
Dejan Sarka wrote:
> Do please check if your databases have the autoclose option turned
> on. This is default for Personal edition, and it takes time to open
> all databases.
I've had a laptop that's been slow for months with QA and SQL EM and
it's been driving me crazy. Even pressing the Cancel button from the
Database properties in SQL EM caused undue database and disk activity.
Checked the databases, and sure enough, there was one user database that
mysteriously had Auto Close turned on. Probably turned it on for testing
and forgot to turn it off.
You fixed me. Thanks.
David Gugick
Imceda Software
www.imceda.com

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service pack 3a. When I right click on Microsoft SQL Servers below the Console Root tree and I select About Sql Server Entrprise Manager, it shows version 8.00.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which is 8.00.760. I tried re-applying the service pack and rebooting and it still shows the incorrect version. Because of this, I am getting incorrect info through Taskpad View for the
correct table sizes in my database. Any ideas?
Thanks,
Nupee
> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)
|||I forgot to mention that this is through my SQL Server 2000 client addition on my desktop. There is nothing wrong with the actual SQL Server. I seem to be the only one in my group experiencing this problem. I am currently using Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it shows
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.
|||I have applied SP3 several times. Don't forget even without using Taskpad, when I check the version of my Entrprise Manager addition, it still does not reflect the SP3 being applied. I don't think this is a database issue. I think it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server. I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>
|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?
|||Yes that is the only instance. However, I do have reporting services loaded as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you have
> installed?
>
>
|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp 3a using a dos prompt and running the setup.bat file. When I tried to apply the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks away for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loaded as well.
> "Aaron [SQL Server MVP]" wrote:

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service
pack 3a. When I right click on Microsoft SQL Servers below the Console Root
tree and I select About Sql Server Entrprise Manager, it shows version 8.00
.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which
is 8.00.760. I tried re-applying the service pack and rebooting and it still
shows the incorrect version. Because of this, I am getting incorrect info t
hrough Taskpad View for the
correct table sizes in my database. Any ideas'
Thanks,
Nupee> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)|||I forgot to mention that this is through my SQL Server 2000 client addition
on my desktop. There is nothing wrong with the actual SQL Server. I seem to
be the only one in my group experiencing this problem. I am currently using
Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it sho
ws
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
>
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.|||I have applied SP3 several times. Don't forget even without using Taskpad, w
hen I check the version of my Entrprise Manager addition, it still does not
reflect the SP3 being applied. I don't think this is a database issue. I thi
nk it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server.
I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?|||Yes that is the only instance. However, I do have reporting services loaded
as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you hav
e
> installed?
>
>|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp
3a using a dos prompt and running the setup.bat file. When I tried to apply
the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks aw
ay for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loade
d as well.
> "Aaron [SQL Server MVP]" wrote:
>

Enterprise Manager Substitute

Is there a product I can use that would allow me to connect to a remote database and manage data locally? I downloaded the trial version and am using enterprise manager, but once the trial has expired, I"ll need something else. My database is hosted at a
commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?
Try this:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||Thanks Aaron. I wanted to send you an email off the list but your email address got bounced so if you can send me your email address, that would be great.
|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.

Enterprise Manager Substitute

Is there a product I can use that would allow me to connect to a remote data
base and manage data locally? I downloaded the trial version and am using en
terprise manager, but once the trial has expired, I"ll need something else.
My database is hosted at a
commercial hosting company and I don't need to do any further development. I
just need to get into the database and make minor data modifications. Is th
ere something more affordable than purchasing the entire SQL Server suite?Try this:
A332CB7F959&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Thanks Aaron. I wanted to send you an email off the list but your email addr
ess got bounced so if you can send me your email address, that would be grea
t.|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.

Enterprise Manager Substitute

Is there a product I can use that would allow me to connect to a remote database and manage data locally? I downloaded the trial version and am using enterprise manager, but once the trial has expired, I"ll need something else. My database is hosted at a commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?Try this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Take out the TRASH.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.

Enterprise Manager reporting wrong server version

I am running MS SQL 2000.

I recently ran a procedure in Query Analyzer from the Master db to
clear out all replication information so I could start/recreate it
again.

After I ran this procedure Enterprise Manager no longer showed the
registered server in the tree. When I tried to re-register it gave me
the following message:

"A connection could not be established to ([Database Name])"

"Reason: [SQL-DMO]Sql Server ([Database Name]) must be upgraded to
version 7.0 or later to be administered by this version of SQL-DMO"

"Please verify that sql is running and check your SQL server
registration properties (by right click on the ([Database Name]) node)
and try again."

I ran the following procedure:

<code>
exec sp_configure N'allow updates', 1
go
reconfigure with override
go

DECLARE @.name varchar(129)
DECLARE @.username varchar(129)
DECLARE @.insname varchar(129)
DECLARE @.delname varchar(129)
DECLARE @.updname varchar(129)
set @.insname=''
set @.updname=''
set @.delname=''

DECLARE list_triggers CURSOR FOR
select distinct replace(artid,'-',''), sysusers.name from
sysmergearticles,sysobjects, sysusers where
sysmergearticles.objid=sysobjects.id
and sysusers.uid=sysobjects.uid

OPEN list_triggers

FETCH NEXT FROM list_triggers INTO @.name, @.username
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping trigger ins_' +@.name
select @.insname='drop trigger ' +@.username+'.ins_'+@.name
exec (@.insname)
PRINT 'dropping trigger upd_' +@.name
select @.updname='drop trigger ' +@.username+'.upd_'+@.name
exec (@.delname)
PRINT 'dropping trigger del_' +@.name
select @.delname='drop trigger ' +@.username+'.del_'+@.name
exec (@.updname)
FETCH NEXT FROM list_triggers INTO @.name, @.username
END

CLOSE list_triggers
DEALLOCATE list_triggers
go

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[syspublications]') and OBJECTPROPERTY(id,
N'IsUserTable')
= 1) begin DECLARE @.name varchar(129)
DECLARE list_pubs CURSOR FOR
SELECT name FROM syspublications

OPEN list_pubs

FETCH NEXT FROM list_pubs INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping publication ' +@.name
EXEC sp_dropsubscription @.publication=@.name, @.article='all',
@.subscriber
='all'
EXEC sp_droppublication @.name
FETCH NEXT FROM list_pubs INTO @.name
END

CLOSE list_pubs
DEALLOCATE list_pubs
end
GO

DECLARE @.name varchar(129)
DECLARE list_replicated_tables CURSOR FOR
SELECT name FROM sysobjects WHERE replinfo <>0
UNION
SELECT name FROM sysmergearticles

OPEN list_replicated_tables

FETCH NEXT FROM list_replicated_tables INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'unmarking replicated table ' +@.name
--select @.name='drop Table ' + @.name
EXEC sp_msunmarkreplinfo @.name
FETCH NEXT FROM list_replicated_tables INTO @.name
END

CLOSE list_replicated_tables
DEALLOCATE list_replicated_tables

GO

UPDATE syscolumns set colstat = colstat & ~4096 WHERE colstat &4096
<>0
GO

UPDATE sysobjects set replinfo=0
GO

DECLARE @.name nvarchar(129)
DECLARE list_views CURSOR FOR
SELECT name FROM sysobjects WHERE type='V' and (name like 'syncobj_%'
or
name
like 'ctsv_%' or name like 'tsvw_%' or name like 'ms_bi%')

OPEN list_views

FETCH NEXT FROM list_views INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping View ' +@.name
select @.name='drop View ' + @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_views INTO @.name
END

CLOSE list_views
DEALLOCATE list_views

GO

DECLARE @.name nvarchar(129)
DECLARE list_procs CURSOR FOR
SELECT name FROM sysobjects WHERE type='p' and (name like 'sp_ins_%'
or
name
like 'sp_MSdel_%' or name like 'sp_MSins_%'or name like 'sp_MSupd_%' or
name
like 'sp_sel_%' or name like 'sp_upd_%')

OPEN list_procs

FETCH NEXT FROM list_procs INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping procs ' +@.name
select @.name='drop procedure ' + @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_procs INTO @.name
END

CLOSE list_procs
DEALLOCATE list_procs

GO

DECLARE @.name nvarchar(129)
DECLARE list_conflict_tables CURSOR FOR
SELECT name From sysobjects WHERE type='u' and name like '_onflict%'

OPEN list_conflict_tables

FETCH NEXT FROM list_conflict_tables INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping conflict_tables ' +@.name
select @.name='drop Table ' + @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_conflict_tables INTO @.name
END

CLOSE list_conflict_tables
DEALLOCATE list_conflict_tables

GO

UPDATE syscolumns set colstat=2 WHERE name='rowguid'

GO

Declare @.name nvarchar(200), @.constraint nvarchar(200)
DECLARE list_rowguid_constraints CURSOR FOR
select sysusers.name+'.'+object_name(sysobjects.parent_ob j),
sysobjects.name
from sysobjects, syscolumns,sysusers where sysobjects.type ='d' and
syscolumns.id=sysobjects.parent_obj
and sysusers.uid=sysobjects.uid
and syscolumns.name='rowguid'

OPEN list_rowguid_constraints

FETCH NEXT FROM list_rowguid_constraints INTO @.name, @.constraint WHILE
@.@.FETCH_STATUS = 0 BEGIN
PRINT 'dropping rowguid constraints ' +@.name
select @.name='ALTER TABLE ' + rtrim(@.name) + ' DROP CONSTRAINT '
+@.constraint
print @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_rowguid_constraints INTO @.name, @.constraint END

CLOSE list_rowguid_constraints
DEALLOCATE list_rowguid_constraints

GO

Declare @.name nvarchar(129), @.constraint nvarchar(129)
DECLARE list_rowguid_indexes CURSOR FOR
select sysusers.name+'.'+object_name(sysindexes.id), sysindexes.name
from
sysindexes, sysobjects,sysusers where sysindexes.name like 'index%' and
sysobjects.id=sysindexes.id and sysusers.uid=sysobjects.uid

OPEN list_rowguid_indexes

FETCH NEXT FROM list_rowguid_indexes INTO @.name, @.constraint WHILE
@.@.FETCH_STATUS = 0 BEGIN
PRINT 'dropping rowguid indexes ' +@.name
select @.name='drop index ' + rtrim(@.name ) + '.' +@.constraint
EXEC sp_executesql @.name
FETCH NEXT FROM list_rowguid_indexes INTO @.name, @.constraint END

CLOSE list_rowguid_indexes
DEALLOCATE list_rowguid_indexes
GO

Declare @.name nvarchar(129), @.constraint nvarchar(129)
DECLARE list_ms_bidi_tables CURSOR FOR
select sysusers.name+'.'+sysobjects.name from
sysobjects,sysusers where sysobjects.name like 'ms_bi%'
and sysusers.uid=sysobjects.uid
and sysobjects.type='u'

OPEN list_ms_bidi_tables

FETCH NEXT FROM list_ms_bidi_tables INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping ms_bidi ' +@.name
select @.name='drop table ' + rtrim(@.name )
EXEC sp_executesql @.name
FETCH NEXT FROM list_ms_bidi_tables INTO @.name
END

CLOSE list_ms_bidi_tables
DEALLOCATE list_ms_bidi_tables

GO

Declare @.name nvarchar(129)
DECLARE list_rowguid_columns CURSOR FOR
select sysusers.name+'.'+object_name(syscolumns.id) from syscolumns,
sysobjects,sysusers where syscolumns.name like 'rowguid' and
object_Name(sysobjects.id) not like 'msmerge%'
and sysobjects.id=syscolumns.id
and sysusers.uid=sysobjects.uid
and sysobjects.type='u' order by 1

OPEN list_rowguid_columns

FETCH NEXT FROM list_rowguid_columns INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping rowguid columns ' +@.name
select @.name='Alter Table ' + rtrim(@.name ) + ' drop column rowguid'
print @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_rowguid_columns INTO @.name
END

CLOSE list_rowguid_columns
DEALLOCATE list_rowguid_columns
go

Declare @.name nvarchar(129)
DECLARE list_views CURSOR FOR

select name From sysobjects where type ='v' and status =-1073741824 and
name
<>'sysmergeextendedarticlesview'

OPEN list_views

FETCH NEXT FROM list_views INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping replication views ' +@.name
select @.name='drop view ' + rtrim(@.name )
print @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_views INTO @.name
END

CLOSE list_views
DEALLOCATE list_views
go
Declare @.name nvarchar(129)
DECLARE list_procs CURSOR FOR

select name From sysobjects where type ='p' and status = -536870912

OPEN list_procs

FETCH NEXT FROM list_procs INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping replication procedure ' +@.name
select @.name='drop procedure ' + rtrim(@.name )
print @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_procs INTO @.name
END

CLOSE list_procs
DEALLOCATE list_procs

go

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergepublications]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergepublications
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergesubscriptions]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergesubscriptions
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[syssubscriptions]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM syssubscriptions
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysarticleupdates]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysarticleupdates
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[systranschemas]') and OBJECTPROPERTY(id,
N'IsUserTable')
= 1)
DELETE FROM systranschemas
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergearticles]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergearticles
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergeschemaarticles]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergeschemaarticles
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergesubscriptions]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergesubscriptions
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysarticles]') and OBJECTPROPERTY(id,
N'IsUserTable') =
1)
DELETE FROM sysarticles
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysschemaarticles]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysschemaarticles
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[syspublications]') and OBJECTPROPERTY(id,
N'IsUserTable')
= 1)
DELETE FROM syspublications
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergeschemachange]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergeschemachange
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysmergesubsetfilters]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM sysmergesubsetfilters
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSdynamicsnapshotjobs]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSdynamicsnapshotjobs
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSdynamicsnapshotviews]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSdynamicsnapshotviews
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_altsyncpartners]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_altsyncpartners
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_contents]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_contents
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_delete_conflicts]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_delete_conflicts
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_errorlineage]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_errorlineage
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_genhistory]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_genhistory
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_replinfo]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_replinfo
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSmerge_tombstone]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSmerge_tombstone
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSpub_identity_range]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSpub_identity_range
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSrepl_identity_range]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSrepl_identity_range
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSreplication_subscriptions]') and
OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSreplication_subscriptions
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[MSsubscription_agents]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
DELETE FROM MSsubscription_agents
GO

if not exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[syssubscriptions]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
create table syssubscriptions (artid int, srvid smallint, dest_db
sysname,
status tinyint, sync_type tinyint, login_name sysname,
subscription_type
int, distribution_jobid binary, timestamp timestamp,update_mode
tinyint,
loopback_detection tinyint, queued_reinit bit)

CREATE TABLE [dbo].[syspublications] (
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[name] [sysname] NOT NULL ,
[pubid] [int] IDENTITY (1, 1) NOT NULL ,
[repl_freq] [tinyint] NOT NULL ,
[status] [tinyint] NOT NULL ,
[sync_method] [tinyint] NOT NULL ,
[snapshot_jobid] [binary] (16) NULL ,
[independent_agent] [bit] NOT NULL ,
[immediate_sync] [bit] NOT NULL ,
[enabled_for_internet] [bit] NOT NULL ,
[allow_push] [bit] NOT NULL ,
[allow_pull] [bit] NOT NULL ,
[allow_anonymous] [bit] NOT NULL ,
[immediate_sync_ready] [bit] NOT NULL ,
[allow_sync_tran] [bit] NOT NULL ,
[autogen_sync_procs] [bit] NOT NULL ,
[retention] [int] NULL ,
[allow_queued_tran] [bit] NOT NULL ,
[snapshot_in_defaultfolder] [bit] NOT NULL ,
[alt_snapshot_folder] [nvarchar] (255) COLLATE
SQL_Latin1_General_CP1_CI_AS
NULL ,
[pre_snapshot_script] [nvarchar] (255) COLLATE
SQL_Latin1_General_CP1_CI_AS
NULL ,
[post_snapshot_script] [nvarchar] (255) COLLATE
SQL_Latin1_General_CP1_CI_AS
NULL ,
[compress_snapshot] [bit] NOT NULL ,
[ftp_address] [sysname] NULL ,
[ftp_port] [int] NOT NULL ,
[ftp_subdirectory] [nvarchar] (255) COLLATE
SQL_Latin1_General_CP1_CI_AS
NULL ,
[ftp_login] [sysname] NULL ,
[ftp_password] [nvarchar] (524) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[allow_dts] [bit] NOT NULL ,
[allow_subscription_copy] [bit] NOT NULL ,
[centralized_conflicts] [bit] NULL ,
[conflict_retention] [int] NULL ,
[conflict_policy] [int] NULL ,
[queue_type] [int] NULL ,
[ad_guidname] [sysname] NULL ,
[backward_comp_level] [int] NOT NULL
) ON [PRIMARY]
GO
create view sysextendedarticlesview
as
SELECT *
FROM sysarticles
UNION ALL
SELECT artid, NULL, creation_script, NULL, description,
dest_object,
NULL, NULL, NULL, name, objid, pubid, pre_creation_cmd, status, NULL,
type,
NULL,
schema_option, dest_owner
FROM sysschemaarticles
go

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysarticles]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[sysarticles]
GO

CREATE TABLE [dbo].[sysarticles] (
[artid] [int] IDENTITY (1, 1) NOT NULL ,
[columns] [varbinary] (32) NULL ,
[creation_script] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL
,
[del_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[dest_table] [sysname] NOT NULL ,
[filter] [int] NOT NULL ,
[filter_clause] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ins_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[name] [sysname] NOT NULL ,
[objid] [int] NOT NULL ,
[pubid] [int] NOT NULL ,
[pre_creation_cmd] [tinyint] NOT NULL ,
[status] [tinyint] NOT NULL ,
[sync_objid] [int] NOT NULL ,
[type] [tinyint] NOT NULL ,
[upd_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[schema_option] [binary] (8) NULL ,
[dest_owner] [sysname] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[sysschemaarticles]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[sysschemaarticles]
GO

CREATE TABLE [dbo].[sysschemaarticles] (
[artid] [int] NOT NULL ,
[creation_script] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL
,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[dest_object] [sysname] NOT NULL ,
[name] [sysname] NOT NULL ,
[objid] [int] NOT NULL ,
[pubid] [int] NOT NULL ,
[pre_creation_cmd] [tinyint] NOT NULL ,
[status] [int] NOT NULL ,
[type] [tinyint] NOT NULL ,
[schema_option] [binary] (8) NULL ,
[dest_owner] [sysname] NULL
) ON [PRIMARY]
GO

declare @.dbname varchar(130)
select @.dbname ='sp_replicationdboption
'+char(39)+db_name()+char(39)+',''merge publish'',''false'''
exec (@.dbname)
select @.dbname ='sp_replicationdboption
'+char(39)+db_name()+char(39)+',''publish'',''fals e'''
exec (@.dbname)

reconfigure with override
go

select db_name()
</code>

Can any one please help me as this is a production machine and needs
fixing ASAP.

Regards,

BenBenzine (bfausti@.gmail.com) writes:

Quote:

Originally Posted by

I recently ran a procedure in Query Analyzer from the Master db to
clear out all replication information so I could start/recreate it
again.
>
After I ran this procedure Enterprise Manager no longer showed the
registered server in the tree. When I tried to re-register it gave me
the following message:
>
"A connection could not be established to ([Database Name])"
>
"Reason: [SQL-DMO]Sql Server ([Database Name]) must be upgraded to
version 7.0 or later to be administered by this version of SQL-DMO"
>
"Please verify that sql is running and check your SQL server
registration properties (by right click on the ([Database Name]) node)
and try again."
>...
Can any one please help me as this is a production machine and needs
fixing ASAP.

OK, so you've learnt a lesson for the next time: run in test before you
run in production.

You run a script that performs a lot of updates to the system tables,
and in many cases to undocumented columns, and now you wonder why your
server is hosed?

I can't tell if there were was more that was harmful, but this cursor
definitely was:

SELECT name FROM sysobjects WHERE type='P' and (name like 'sp_ins_%'
or name like 'sp_MSdel_%' or name like 'sp_MSins_%'or
name like 'sp_MSupd_%' or name like 'sp_sel_%' or name like 'sp_upd_%')

OPEN list_procs

FETCH NEXT FROM list_procs INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping procs ' +@.name
select @.name='drop procedure ' + @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_procs INTO @.name
END

The SELECT hits 30 system procedures on my server, and far from all
are related to replication, for instance sp_updatestats and
sp_updateextendedproperty.

I would recommand that you at first possible maintenance window, detach
all databases and use the rebuildm tool to rebuild the master database.
Or simply reinstall SQL Server. Whatever, don't forget to reapply the
service pack.

If it's difficult to find the time for a reinstall, I suggest that you
open a case with Microsoft. I don't really want to guide you which
scripts to run, as my guidance could be wrong.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thank you for your reply.

Unfortunately I didn't have the luxury of a test environment, so I
took a big risk I know. Thankfully we had backups running on Veritas, I
restored to a previous version of the master and msdb databases and
this fixed my problem.

Erland Sommarskog wrote:

Quote:

Originally Posted by

Benzine (bfausti@.gmail.com) writes:

Quote:

Originally Posted by

I recently ran a procedure in Query Analyzer from the Master db to
clear out all replication information so I could start/recreate it
again.

After I ran this procedure Enterprise Manager no longer showed the
registered server in the tree. When I tried to re-register it gave me
the following message:

"A connection could not be established to ([Database Name])"

"Reason: [SQL-DMO]Sql Server ([Database Name]) must be upgraded to
version 7.0 or later to be administered by this version of SQL-DMO"

"Please verify that sql is running and check your SQL server
registration properties (by right click on the ([Database Name]) node)
and try again."
...
Can any one please help me as this is a production machine and needs
fixing ASAP.

>
OK, so you've learnt a lesson for the next time: run in test before you
run in production.
>
You run a script that performs a lot of updates to the system tables,
and in many cases to undocumented columns, and now you wonder why your
server is hosed?
>
I can't tell if there were was more that was harmful, but this cursor
definitely was:
>
SELECT name FROM sysobjects WHERE type='P' and (name like 'sp_ins_%'
or name like 'sp_MSdel_%' or name like 'sp_MSins_%'or
name like 'sp_MSupd_%' or name like 'sp_sel_%' or name like 'sp_upd_%')
>
OPEN list_procs
>
FETCH NEXT FROM list_procs INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
PRINT 'dropping procs ' +@.name
select @.name='drop procedure ' + @.name
EXEC sp_executesql @.name
FETCH NEXT FROM list_procs INTO @.name
END
>
The SELECT hits 30 system procedures on my server, and far from all
are related to replication, for instance sp_updatestats and
sp_updateextendedproperty.
>
I would recommand that you at first possible maintenance window, detach
all databases and use the rebuildm tool to rebuild the master database.
Or simply reinstall SQL Server. Whatever, don't forget to reapply the
service pack.
>
If it's difficult to find the time for a reinstall, I suggest that you
open a case with Microsoft. I don't really want to guide you which
scripts to run, as my guidance could be wrong.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Enterprise Manager in version 2000

Typically when I bring up Enterprise Mgr, I get the options to look at the databases, tables, etc. Now, when I choose EM, it brings up the Microsoft Management Console without anything in it except 'Console', 'Window', and 'Help'. When I open a new window, I can see the databases etc. but the top of the window says 'SQL Server Enterprise Manager [2:Console Root\Microsoft SQL Servers]' and a few of the icons are grayed out like 'New Database', 'New Login', and 'New Job'. I haven't changed anything that I know of. Please Help!

thx

Kat

A reinstallation of SQL Server solved the problem. I think it came up because I'm working on an old laptop while my newer one is getting fixed. Not much space, memory, and it is slow. Oh, the joy of technology and the obsolescence of all machines...

Kat

enterprise manager doesn't load

me bad - i installed visual studio (with sql express) then put the patches on
and sp2 for sql express.. then loaded the development version -- now
enterprise manager for sql 2005 won't load --
how do i make it - it doesn't give an error - just isn't there.
Do you mean Management Studio?
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.
|||yes - it turns out that you have to have IIS installed to allow the
management studio to work - seems stupid to me - but it is what it is.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Do you mean Management Studio?
>
> "Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
> news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
>
>
|||> yes - it turns out that you have to have IIS installed to allow the
> management studio to work - seems stupid to me - but it is what it is.
Well, that's not true because I use Management Studio on several systems
without IIS configured. But maybe you tripped something else when you
installed IIS. <shrug>
|||You don't need to have IIS installed to run SQL Server 05 or any of it's
tools.
Your issue may be caused by conflicts with .NET framework 2.0. Try
uninstalling the 2.0 framework and then reinstalling the latest copies from
Microsoft.
Search MS knowledge base and you'll find that many users have had problems
with sql server 05 and .NET 2.0
Sincerely,
John K
Knowledgy Consulting, LLC
www.knowledgy.org
Atlanta's Business Intelligence and Knowledge Management Experts
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.

Enterprise Manager 2/ Me 0

Oi! Not that anyone will ever see this post again - but it was McAfee's
Entercept Agent causing the problem - the version we had apparently didn't
like comments (!) in stored procedures, and when it came across one, would
destabilize the server and cause it to crash (v 42.58)..... the latest
version (42.59) fixed the problem.
"B@.DJJ" wrote:

> Ahoy All!
> Say I come in, bright-eyed-and-bushy-tailed in the AM and say "Hey! I thi
nk
> I'll add a field to a table this Bright and Glorious morning!" so I fire u
p
> Enterprise Manager (v 2.0) with the SQL Enterprise Manager (v 8.0) (runnin
g
> on XP SP2 hitting a SQL Server 2000 SP4 DB running on W2k3 Server) and go
to
> design view, add my tiny little field (this time an int, default 0), click
> Apply, click Yes Please (actually OK), and then, lo and behold, I get this
> little gem:
> 17310 :
> SqlDumpExceptionHandler: Process 848 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> No further access via EM or QA at that point.
> So I stop the SQLService on the server, count to 10 and sprinkle a little
> pixie dust about, restart the SQLService, and voila! sometimes my field i
s
> in the table, sometimes it isn't, and if it isn't, I add it in, click Appl
y,
> click Yes Please, and double-viola! It works like a charm - then, for the
> rest of the day, all is well (can add fields, update sprocs, modify trigge
rs,
> you-name-it).
> Any thoughts and suggestions would be appreciated. Haven't tried it via Q
A,
> though, next time I think I'll give 'er a whirl.
> Thanks
>Simply ridiculous.
ML
http://milambda.blogspot.com/

Enterprise Manager

Hi all,

I am an IT student just getting aquainted with Sequel Server. I downloaded a trial version of 2005, and am having trouble finding Enterprise Manager(which my book tells me I need to use for implementing a database). All I really need to do is learn how to design and implement database tables, with their keys and relationships, and populate them to practice querys. Can anyone help me find the applicable portion of the 2005 environment to do this? I don't have a server to hook to, just my laptop.

Thank You!

Jimbo

First of all you need to download .. downloadable version of SQL Server 2005 ie. SQL Server 2005 Express. the trialo version you mentioned is SQL Server express then its ok... Second thing is there is no more Enterprise Manager in SQL Server 2005 .. not the Tool is Called SQL Server Management Studio(SSMS) .. with lot of enhancement. So while instaling , you must choose "WorkStation Components" to get SSMS it installed.

if you are not installed sql server experss .. you can download it from this link

http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

If you already have SQL Server 2005 cd then while installing choose the Workstation components as i mentioned earlier

Madhu

|||

Hi,

I've been trying to get this working as well so I can brush up on my skills but can't get at the Management Studio. I didn't see any workstation component options when I was installing it. Can anyone point me in the right direction? Very simply please!

Cheers

Chris

|||The "normal" edition of SQL Server Express does not ship with any client components. You will either have to separately download the client components on [1] opr install the advanced edition from [2].

[1] http://go.microsoft.com/fwlink/?LinkId=65110
[2] http://go.microsoft.com/fwlink/?LinkId=65109

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi all,

I actually found a downloadable version of SQL Server 2000 that is serving the purpose for class quite well. Thank you for letting me know about the Express versions of 2005. I wish our class was using that one instead, it makes sense to me to use the version that is more up to date.

Have a great day!

JImbo