I have the following (VB.NET) code:
For some reason, I can't get this code to return anything but a ResultSet
with 0 rows. Any ideas?
Public Function GetDependencies(ByVal db As SQLDMO.Database2) As String
Dim objSP As SQLDMO.StoredProcedure2 = db.StoredProcedures.Item(Me.Text)
Dim objQueryResults As SQLDMO.QueryResults = _
objSP.EnumDependencies(SQLDMO.SQLDMO_DEPENDENCY_TYPE.SQLDMODep_Valid)
Dim sb As New System.Text.StringBuilder(4096)
Dim writer As New System.IO.StringWriter(sb)
For i As Integer = 1 To objQueryResults.ResultSets
objQueryResults.CurrentResultSet = i
For j As Integer = 1 To objQueryResults.Rows
For k As Integer = 1 To objQueryResults.Columns
writer.Write(objQueryResults.ColumnName(k) & ": ")
writer.WriteLine(objQueryResults.GetColumnString(j, k))
Next
Next
Next
writer.Flush()
writer.Close()
Return sb.ToString()
End Function
Developer ExtraordinaireHi
Don't forget, in SQL 7.0 and 2000, dependency information is not guaranteed
to be correct due the Deferred Name resolution.
Have you looked in sysdepends if there is information there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<developerExtraordinaire@.spamMeAndDie.com> wrote in message
news:ewd2zkeGFHA.1740@.TK2MSFTNGP09.phx.gbl...
> I have the following (VB.NET) code:
> For some reason, I can't get this code to return anything but a ResultSet
> with 0 rows. Any ideas?
> Public Function GetDependencies(ByVal db As SQLDMO.Database2) As String
> Dim objSP As SQLDMO.StoredProcedure2 =
db.StoredProcedures.Item(Me.Text)
> Dim objQueryResults As SQLDMO.QueryResults = _
> objSP.EnumDependencies(SQLDMO.SQLDMO_DEPENDENCY_TYPE.SQLDMODep_Valid)
> Dim sb As New System.Text.StringBuilder(4096)
> Dim writer As New System.IO.StringWriter(sb)
> For i As Integer = 1 To objQueryResults.ResultSets
> objQueryResults.CurrentResultSet = i
> For j As Integer = 1 To objQueryResults.Rows
> For k As Integer = 1 To objQueryResults.Columns
> writer.Write(objQueryResults.ColumnName(k) & ": ")
> writer.WriteLine(objQueryResults.GetColumnString(j, k))
> Next
> Next
> Next
> writer.Flush()
> writer.Close()
> Return sb.ToString()
> End Function
>
> Developer Extraordinaire
>
Showing posts with label return. Show all posts
Showing posts with label return. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Enumerate Users in NT Groups
Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
Julian
Julian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>
|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who
> is
>
sql
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
Julian
Julian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>
|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who
> is
>
sql
Enumerate Users in NT Groups
Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who[vbcol=seagreen]
> is
>
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who[vbcol=seagreen]
> is
>
Enumerate Users in NT Groups
Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How Can I list the users in an NT group, ie I have user Joe Bloggs
who
> is
> > in NT Group Domain/Users.
> >
> > I need to return to a client app what group they are in.
> >
> > Julian
> >
> >
>
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How Can I list the users in an NT group, ie I have user Joe Bloggs
who
> is
> > in NT Group Domain/Users.
> >
> > I need to return to a client app what group they are in.
> >
> > Julian
> >
> >
>
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.
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.
EnumAvailableSqlServers does not return all instances
Hello All,
When I execute
SmoApplication.EnumAvailableSqlServers("AServerNameHere"), passing in the hostname of a system I know to be running multiple instances (2x 2000 and 1 x 2005), it only returns/finds the default unnamed instance. I thought this could have been some form of security issue as per http://blogs.msdn.com/sql_protocols/archive/2005/09/24/473502.aspx, however this is not the case because:
1. When I execute SmoAppliction.EnumAvailableSqlServers() (ie - without passing in a servername) ALL instances are discovered on the above hostname.
2. If i maunally execute SmoApplication.EnumAvailableSqlServers("AServernamehere\Instance") it successfully returns/discovers the instance I explicitly pass it.
Isn't this method supposed to return all instances running on the hostname that is specified? If so, in what manner are you to pass in the hostname ("Hostname\%" or "Hostname\*")?
Cheers
Rob
Have you tried passing in the hostname only without the instance name?|||Hi Michiel,
Absolutely; this is the issue as when I pass in the hostname, EnumAvailableSqlServers only returns the default unnamed instance and not the other n named instances.
Cheers
Rob
|||Sorry to BTT, but does anyone have any info on this?sqlEnumAvailableSqlServers does not return all instances
Hello All,
When I execute
SmoApplication.EnumAvailableSqlServers("AServerNameHere"), passing in the hostname of a system I know to be running multiple instances (2x 2000 and 1 x 2005), it only returns/finds the default unnamed instance. I thought this could have been some form of security issue as per http://blogs.msdn.com/sql_protocols/archive/2005/09/24/473502.aspx, however this is not the case because:
1. When I execute SmoAppliction.EnumAvailableSqlServers() (ie - without passing in a servername) ALL instances are discovered on the above hostname.
2. If i maunally execute SmoApplication.EnumAvailableSqlServers("AServernamehere\Instance") it successfully returns/discovers the instance I explicitly pass it.
Isn't this method supposed to return all instances running on the hostname that is specified? If so, in what manner are you to pass in the hostname ("Hostname\%" or "Hostname\*")?
Cheers
Rob
Have you tried passing in the hostname only without the instance name?|||Hi Michiel,
Absolutely; this is the issue as when I pass in the hostname, EnumAvailableSqlServers only returns the default unnamed instance and not the other n named instances.
Cheers
Rob
|||Sorry to BTT, but does anyone have any info on this?Sunday, March 11, 2012
Enterprise Manager Open Table/Return All Rows
After upgrading Windows 2000 server to Windows Server 2003 Standard Edition
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWD
I'd try re-installing the tools...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>
|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Edition
Table/Return
>
|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Table/Return
>
>
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWD
I'd try re-installing the tools...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>
|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Edition
Table/Return
>
|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Table/Return
>
>
Enterprise Manager Open Table/Return All Rows
After upgrading Windows 2000 server to Windows Server 2003 Standard Edition
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWDI'd try re-installing the tools...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Edition
Table/Return[vbcol=seagreen]
>|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Table/Return
>
>
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWDI'd try re-installing the tools...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Edition
Table/Return[vbcol=seagreen]
>|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> Table/Return
>
>
Enterprise Manager Open Table/Return All Rows
After upgrading Windows 2000 server to Windows Server 2003 Standard Edition
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWDI'd try re-installing the tools...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> > After upgrading Windows 2000 server to Windows Server 2003 Standard
> Edition
> > I'm receiving a '8007007F Unknown Error' when I use the 'Open
Table/Return
> > All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> > Although not exactly my issue KnowledgeBase Article 817301 suggested
> > re-registering query.dll and tquery.dll. I've tried this and I'm still
> > having the same issue. If anyone is knows of this issue please respond.
> >
> > Thank-you,
> > EWD
> >
> >
>|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> > I'd try re-installing the tools...
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> > news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> > > After upgrading Windows 2000 server to Windows Server 2003 Standard
> > Edition
> > > I'm receiving a '8007007F Unknown Error' when I use the 'Open
> Table/Return
> > > All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> > > Although not exactly my issue KnowledgeBase Article 817301 suggested
> > > re-registering query.dll and tquery.dll. I've tried this and I'm still
> > > having the same issue. If anyone is knows of this issue please respond.
> > >
> > > Thank-you,
> > > EWD
> > >
> > >
> >
> >
>
>
I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
Although not exactly my issue KnowledgeBase Article 817301 suggested
re-registering query.dll and tquery.dll. I've tried this and I'm still
having the same issue. If anyone is knows of this issue please respond.
Thank-you,
EWDI'd try re-installing the tools...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> After upgrading Windows 2000 server to Windows Server 2003 Standard
Edition
> I'm receiving a '8007007F Unknown Error' when I use the 'Open Table/Return
> All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> Although not exactly my issue KnowledgeBase Article 817301 suggested
> re-registering query.dll and tquery.dll. I've tried this and I'm still
> having the same issue. If anyone is knows of this issue please respond.
> Thank-you,
> EWD
>|||Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
the SQL Server but I received the same error.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> I'd try re-installing the tools...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> > After upgrading Windows 2000 server to Windows Server 2003 Standard
> Edition
> > I'm receiving a '8007007F Unknown Error' when I use the 'Open
Table/Return
> > All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> > Although not exactly my issue KnowledgeBase Article 817301 suggested
> > re-registering query.dll and tquery.dll. I've tried this and I'm still
> > having the same issue. If anyone is knows of this issue please respond.
> >
> > Thank-you,
> > EWD
> >
> >
>|||Ernest, I am receiving the same error. Can you tell me if you were able to
fix your issue?
Thanks
Derek
"Ernest" wrote:
> Thanks Wayne, I tried re-installing the tools and uninstall/re-install of
> the SQL Server but I received the same error.
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uwOsI0lxEHA.1196@.TK2MSFTNGP15.phx.gbl...
> > I'd try re-installing the tools...
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Ernest Dungy" <ewdungy@.msn-DONTSENDSPAM.com> wrote in message
> > news:Ormc6wexEHA.1988@.TK2MSFTNGP12.phx.gbl...
> > > After upgrading Windows 2000 server to Windows Server 2003 Standard
> > Edition
> > > I'm receiving a '8007007F Unknown Error' when I use the 'Open
> Table/Return
> > > All Rows' right click option in Enterprise Manager (SQL 2000 sp3a).
> > > Although not exactly my issue KnowledgeBase Article 817301 suggested
> > > re-registering query.dll and tquery.dll. I've tried this and I'm still
> > > having the same issue. If anyone is knows of this issue please respond.
> > >
> > > Thank-you,
> > > EWD
> > >
> > >
> >
> >
>
>
Enterprise Manager not displaying Bigint's
I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyzer
> it is displayed correctly.|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
> > I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> > Manager, whereby if you do a return all rows on a table that contains a
> > bigint column it show as blank. Yet if you do a select * from query analyzer
> > it is displayed correctly.|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
> > Hi Russell
> >
> > Have you service packed this system?
> >
> > John
> >
> > "Russell" wrote:
> >
> > > I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> > > Manager, whereby if you do a return all rows on a table that contains a
> > > bigint column it show as blank. Yet if you do a select * from query analyzer
> > > it is displayed correctly.
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyzer
> it is displayed correctly.|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
> > I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> > Manager, whereby if you do a return all rows on a table that contains a
> > bigint column it show as blank. Yet if you do a select * from query analyzer
> > it is displayed correctly.|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
> > Hi Russell
> >
> > Have you service packed this system?
> >
> > John
> >
> > "Russell" wrote:
> >
> > > I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> > > Manager, whereby if you do a return all rows on a table that contains a
> > > bigint column it show as blank. Yet if you do a select * from query analyzer
> > > it is displayed correctly.
Enterprise Manager not displaying Bigint's
I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.
Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyzer
> it is displayed correctly.
|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
[vbcol=seagreen]
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.
Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyzer
> it is displayed correctly.
|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
[vbcol=seagreen]
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
Enterprise Manager not displaying Bigint's
I am currently having an issue on one of our pc's here in SQL 2000 Enterpris
e
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterpr
ise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyz
er
> it is displayed correctly.|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
>|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
[vbcol=seagreen]
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
>
e
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterpr
ise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyz
er
> it is displayed correctly.|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
>|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
[vbcol=seagreen]
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
>
Wednesday, March 7, 2012
Enterprise Manager Error Pls Help
Hi All,
Sqlserver 7.
From the Enterprise Manager when i right click on a table
and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error:
Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Sqlserver 7.
From the Enterprise Manager when i right click on a table
and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error:
Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Enterprise Manager error
After installing Enterprise Manager on a new HP laptop running XP Pro sp2, I get the following error message when to trying to "Return all rows" from a table. "Provider cannot be found. It may not be properly installed."
Everything I read on the internet says to install or reinstall Jet 4.0 sp8, but this has not solved the problem. I've also installed the latest MDAC...MDAC 2.8 SP1 on Windows XP SP2, and ran the compchecker, everthing checks out ok. Any ideas?
Thanks
T.C.
I just installed SQL2000 sp4 hoping the error would go away...it didn't.
Did your problem ever get resolved?
|||
Hello,
I had searched through Google and Microsoft website for the error message. I find a few matches. You could try the solution suggested in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44561. Another link with suggestion from alleged Microsoft online support is http://www.mcse.ms/message201860.html. It could be due to MDAC issue.
Enterprise Manager error
After installing Enterprise Manager on a new HP laptop running XP Pro sp2, I get the following error message when to trying to "Return all rows" from a table. "Provider cannot be found. It may not be properly installed."
Everything I read on the internet says to install or reinstall Jet 4.0 sp8, but this has not solved the problem. I've also installed the latest MDAC...MDAC 2.8 SP1 on Windows XP SP2, and ran the compchecker, everthing checks out ok. Any ideas?
Thanks
T.C.
I just installed SQL2000 sp4 hoping the error would go away...it didn't.
Did your problem ever get resolved?
|||
Hello,
I had searched through Google and Microsoft website for the error message. I find a few matches. You could try the solution suggested in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44561. Another link with suggestion from alleged Microsoft online support is http://www.mcse.ms/message201860.html. It could be due to MDAC issue.
Sunday, February 26, 2012
Enterprise Manager error
After installing Enterprise Manager on a new HP laptop running XP Pro sp2, I get the following error message when to trying to "Return all rows" from a table. "Provider cannot be found. It may not be properly installed."
Everything I read on the internet says to install or reinstall Jet 4.0 sp8, but this has not solved the problem. I've also installed the latest MDAC...MDAC 2.8 SP1 on Windows XP SP2, and ran the compchecker, everthing checks out ok. Any ideas?
Thanks
T.C.
I just installed SQL2000 sp4 hoping the error would go away...it didn't.
Did your problem ever get resolved?|||
Hello,
I had searched through Google and Microsoft website for the error message. I find a few matches. You could try the solution suggested in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44561. Another link with suggestion from alleged Microsoft online support is http://www.mcse.ms/message201860.html. It could be due to MDAC issue.
Sunday, February 19, 2012
enterprise manager "return all rows" error
in enterprise manager, when i select a table and "return all rows" or "query" , SQL returns an error "provider cannot be found". I can successfully run a query in query analyzer. I've reinstalled SQL and it's still not working. It seemed to be working fine a couple weeks ago when i was working on crystal reports.Hi,
It could be an MDAC problem. Try loading the MDAC for the version of SQL
you are using.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx . Free icon extraction
program
http://www.ag-software.com. Free programming tools
"az" <anonymous@.discussions.microsoft.com> wrote in message
news:8E3D5D69-C0E8-43D6-BE2C-8D24DE519A6D@.microsoft.com...
> in enterprise manager, when i select a table and "return all rows" or
"query" , SQL returns an error "provider cannot be found". I can
successfully run a query in query analyzer. I've reinstalled SQL and it's
still not working. It seemed to be working fine a couple weeks ago when i
was working on crystal reports.
>
It could be an MDAC problem. Try loading the MDAC for the version of SQL
you are using.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.aspx. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.aspx. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.aspx . Free icon extraction
program
http://www.ag-software.com. Free programming tools
"az" <anonymous@.discussions.microsoft.com> wrote in message
news:8E3D5D69-C0E8-43D6-BE2C-8D24DE519A6D@.microsoft.com...
> in enterprise manager, when i select a table and "return all rows" or
"query" , SQL returns an error "provider cannot be found". I can
successfully run a query in query analyzer. I've reinstalled SQL and it's
still not working. It seemed to be working fine a couple weeks ago when i
was working on crystal reports.
>
Friday, February 17, 2012
Enterprise Manager
I went to Enterprise Manager to examine database
table ... Highlightlighted desired table, right
clicked ... went to Open Table / Return All Rows,
clicked ... received an error [Unknown error: 800700F]
I have cleaned up database, re-installed software several
times ... only to arrive at the same result.
Note: MS SQL is running as Local
Please advice ... I have examined rights as well!
Ellie
What happens if execute this from Query Analyzer?
(you will have to replace dbname, owner, and table so that it works in your
environment)
SELECT * FROM [dbname].[owner].[table]
If it works, the problem is probably isolated to Enterprise Manager.
I found an answer posted by Baisong Wei that might solve the problem:
=============================
From my experience, if you meets error 800700f, you could download the SQL
Server SP3 and the latest MDAC, then reboot you computer.
You could download them at:
Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/downloads/d...DisplayLang=en
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/d...DisplayLang=en
Hope this helps. If you still have question, please feel free to post
message here and I am ready to help. Thanks.
Best regards
Baisong Wei
Microsoft Online Support
=============================
Keith
"Ellie" <ellie@.emsplus.net> wrote in message
news:2d04701c46a96$2140ccb0$a601280a@.phx.gbl...
> I went to Enterprise Manager to examine database
> table ... Highlightlighted desired table, right
> clicked ... went to Open Table / Return All Rows,
> clicked ... received an error [Unknown error: 800700F]
> I have cleaned up database, re-installed software several
> times ... only to arrive at the same result.
> Note: MS SQL is running as Local
> Please advice ... I have examined rights as well!
> Ellie
|||These may be helpful as well:
http://groups.google.com/groups?hl=e...ic.sqlserver.*
http://groups.google.com/groups?q=%2...x.gb l&rnum=1
Keith
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:eXtiIxpaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> What happens if execute this from Query Analyzer?
> (you will have to replace dbname, owner, and table so that it works in
your
> environment)
> SELECT * FROM [dbname].[owner].[table]
> If it works, the problem is probably isolated to Enterprise Manager.
>
> I found an answer posted by Baisong Wei that might solve the problem:
> =============================
> From my experience, if you meets error 800700f, you could download the SQL
> Server SP3 and the latest MDAC, then reboot you computer.
> You could download them at:
> Microsoft SQL Server 2000 Service Pack 3a
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> Microsoft Data Access Components (MDAC) 2.8
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> Hope this helps. If you still have question, please feel free to post
> message here and I am ready to help. Thanks.
> Best regards
> Baisong Wei
> Microsoft Online Support
> =============================
> --
> Keith
>
> "Ellie" <ellie@.emsplus.net> wrote in message
> news:2d04701c46a96$2140ccb0$a601280a@.phx.gbl...
>
|||Keith:
Thanks, I found that installing the SP3 resolved the problem and I did
notice it updated MDAC as well.
Your time is most appreciated.
Ellie Warther
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
table ... Highlightlighted desired table, right
clicked ... went to Open Table / Return All Rows,
clicked ... received an error [Unknown error: 800700F]
I have cleaned up database, re-installed software several
times ... only to arrive at the same result.
Note: MS SQL is running as Local
Please advice ... I have examined rights as well!
Ellie
What happens if execute this from Query Analyzer?
(you will have to replace dbname, owner, and table so that it works in your
environment)
SELECT * FROM [dbname].[owner].[table]
If it works, the problem is probably isolated to Enterprise Manager.
I found an answer posted by Baisong Wei that might solve the problem:
=============================
From my experience, if you meets error 800700f, you could download the SQL
Server SP3 and the latest MDAC, then reboot you computer.
You could download them at:
Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/downloads/d...DisplayLang=en
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/d...DisplayLang=en
Hope this helps. If you still have question, please feel free to post
message here and I am ready to help. Thanks.
Best regards
Baisong Wei
Microsoft Online Support
=============================
Keith
"Ellie" <ellie@.emsplus.net> wrote in message
news:2d04701c46a96$2140ccb0$a601280a@.phx.gbl...
> I went to Enterprise Manager to examine database
> table ... Highlightlighted desired table, right
> clicked ... went to Open Table / Return All Rows,
> clicked ... received an error [Unknown error: 800700F]
> I have cleaned up database, re-installed software several
> times ... only to arrive at the same result.
> Note: MS SQL is running as Local
> Please advice ... I have examined rights as well!
> Ellie
|||These may be helpful as well:
http://groups.google.com/groups?hl=e...ic.sqlserver.*
http://groups.google.com/groups?q=%2...x.gb l&rnum=1
Keith
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:eXtiIxpaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> What happens if execute this from Query Analyzer?
> (you will have to replace dbname, owner, and table so that it works in
your
> environment)
> SELECT * FROM [dbname].[owner].[table]
> If it works, the problem is probably isolated to Enterprise Manager.
>
> I found an answer posted by Baisong Wei that might solve the problem:
> =============================
> From my experience, if you meets error 800700f, you could download the SQL
> Server SP3 and the latest MDAC, then reboot you computer.
> You could download them at:
> Microsoft SQL Server 2000 Service Pack 3a
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> Microsoft Data Access Components (MDAC) 2.8
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> Hope this helps. If you still have question, please feel free to post
> message here and I am ready to help. Thanks.
> Best regards
> Baisong Wei
> Microsoft Online Support
> =============================
> --
> Keith
>
> "Ellie" <ellie@.emsplus.net> wrote in message
> news:2d04701c46a96$2140ccb0$a601280a@.phx.gbl...
>
|||Keith:
Thanks, I found that installing the SP3 resolved the problem and I did
notice it updated MDAC as well.
Your time is most appreciated.
Ellie Warther
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Subscribe to:
Posts (Atom)