Enumerating Stored Procedure dependencies using SQL-DMO

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
>

Enumerating SQL Server database tables rows and sprocs using MFC

Hi,
I've been looking around for a while now after an efficient way to enumerate
tables, rows and sprocs of a MsSQL database. The best I could come up with
was SQL DMO, but one cannot have it installed without installing SQL Server
itself or MSDE, so I'm looking for alternative.
After a table name was fetched, I will need to know the rows it contains,
what type they are, and what are the indexes and identity defined for this
table. Effectively, if I could somehow get the CREATE SQL statement from the
DB itself that would be ideal. Also, I will need a way to get the sprocs
code from the DB, and all that without having any prequisites on either
sides - client and server.
I'm using VC++ with MFC. No managed C++ or .NET, unless I can use the
algorythm in an unmanaged enviroment.
Any links, articles, replies and sample code would be highly appreciated.
Thanks in advance,
Stilgar.Stilgar wrote:
> Hi,
> I've been looking around for a while now after an efficient way to enumera
te
> tables, rows and sprocs of a MsSQL database. The best I could come up with
> was SQL DMO, but one cannot have it installed without installing SQL Serve
r
> itself or MSDE, so I'm looking for alternative.
> After a table name was fetched, I will need to know the rows it contains,
> what type they are, and what are the indexes and identity defined for this
> table. Effectively, if I could somehow get the CREATE SQL statement from t
he
> DB itself that would be ideal. Also, I will need a way to get the sprocs
> code from the DB, and all that without having any prequisites on either
> sides - client and server.
> I'm using VC++ with MFC. No managed C++ or .NET, unless I can use the
> algorythm in an unmanaged enviroment.
> Any links, articles, replies and sample code would be highly appreciated.
> Thanks in advance,
> Stilgar.
To connect to the database you'll normally need an ODBC or OLEDB driver
and the usual way to get that is to install the client connectivity
from the SQL Server disc or install MDAC from microsoft.com (unless you
plan to write your own ODBC/OLEDB client).
The metadata is available in the ADO object model or through TSQL
commands that return a recordset. SQL Server provides the Information
Schema views for that purpose and you can read about them in Books
Online.
David Portas
SQL Server MVP
--|||Will DESCRIBE <tablename> work on MsSql?
For each row simply do SELECT * FROM <table>
- MR
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:%23RANlXE7FHA.3876@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I've been looking around for a while now after an efficient way to
> enumerate tables, rows and sprocs of a MsSQL database.|||DESCRIBE <tablename> doesn't seem to work with MsSQL. I've executed it and
it errored.
How can I get the field types using SELECT *? Not to mention indexes and
determine what is the identity field?
Stilgar.
"Mark Randall" <markyr@.gmail.com> wrote in message
news:%23oLYohE7FHA.3588@.TK2MSFTNGP15.phx.gbl...
> Will DESCRIBE <tablename> work on MsSql?
> For each row simply do SELECT * FROM <table>
> - MR
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:%23RANlXE7FHA.3876@.TK2MSFTNGP09.phx.gbl...
>|||I'm using ODBC. Can you shortlist the main TSQL commands? I couldn't find
them myself, as I don't know what to look for exactly here.
How can MDAC help here?
Stilgar.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1132322428.645339.183190@.g44g2000cwa.googlegroups.com...
> Stilgar wrote:
> To connect to the database you'll normally need an ODBC or OLEDB driver
> and the usual way to get that is to install the client connectivity
> from the SQL Server disc or install MDAC from microsoft.com (unless you
> plan to write your own ODBC/OLEDB client).
> The metadata is available in the ADO object model or through TSQL
> commands that return a recordset. SQL Server provides the Information
> Schema views for that purpose and you can read about them in Books
> Online.
> --
> David Portas
> SQL Server MVP
> --
>|||http://msdn.microsoft.com/library/d...r />
_9sfo.asp
Click 'Up One Level' and there you go ... I tried to give you that direct
link but ...
-Mark
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:%231s$CpE7FHA.476@.TK2MSFTNGP15.phx.gbl...
> I'm using ODBC. Can you shortlist the main TSQL commands? I couldn't find
> them myself, as I don't know what to look for exactly here.
> How can MDAC help here?
> Stilgar.
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1132322428.645339.183190@.g44g2000cwa.googlegroups.com...
>|||Hello Stilgar,
Take a look at the GetSchema() method using the most recent SqlClient bit
drops. BobB has good article about them at [0], but that's framed in ADO.NET
terms. I believe you can use the same patterns in C++/MFC, however. Just
harder :)
[0] http://msdn.microsoft.com/library/d...net2schemas.asp
Long live the fighters!
Kent Tegels
DevelopMentor|||I got an even better one - EXEC sp_tables, sp_columns <table>,
sp_stored_procedures.
Thanks for your help.
Stilgar.
"Mark Nijhof" <Mark@.Nijhof.com> wrote in message
news:urPdcHF7FHA.1184@.TK2MSFTNGP12.phx.gbl...
> http://msdn.microsoft.com/library/d.../>
es_9sfo.asp
> Click 'Up One Level' and there you go ... I tried to give you that direct
> link but ...
> -Mark
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:%231s$CpE7FHA.476@.TK2MSFTNGP15.phx.gbl...
>|||...And I have an even better Idea;
go to
http://dev.mysql.com/downloads/
and download the MySQL++, this makes connecting from VC++ to a MySQL
database really easy, no ODBC, or any other connectors, straight to the
MySQL database.
John
The_Code_Master@.hotmail.com
"Stilgar" <stilgar@.divrei-tora.com> wrote in message
news:eg$xYBU7FHA.2036@.TK2MSFTNGP14.phx.gbl...
> I got an even better one - EXEC sp_tables, sp_columns <table>,
> sp_stored_procedures.
> Thanks for your help.
> Stilgar.
> "Mark Nijhof" <Mark@.Nijhof.com> wrote in message
> news:urPdcHF7FHA.1184@.TK2MSFTNGP12.phx.gbl...
http://msdn.microsoft.com/library/d...-us/tsqlref/ts_
sa-ses_9sfo.asp
direct
find
message
either
driver
you
>|||Sure, only problem is I asked about MS SQL Server, not MySQL. Thanks, but
I'm already familiar with it.
Stilgar.
"The Code Master" <The_Code_Master@.hotmail.com> wrote in message
news:BPOff.21604$tV6.12458@.newssvr27.news.prodigy.net...
> ...And I have an even better Idea;
> go to
> http://dev.mysql.com/downloads/
> and download the MySQL++, this makes connecting from VC++ to a MySQL
> database really easy, no ODBC, or any other connectors, straight to the
> MySQL database.
> John
> The_Code_Master@.hotmail.com
>
> "Stilgar" <stilgar@.divrei-tora.com> wrote in message
> news:eg$xYBU7FHA.2036@.TK2MSFTNGP14.phx.gbl...
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_[/ur
l]
> sa-ses_9sfo.asp
> direct
> find
> message
> either
> driver
> you
>

enumerating Foreach Loop from rowset

Please let me know if I am on the right track here.

I have an Execute SQL Task that selects multiple rows from an OLE DB connection, each row containing 3 columns (data types = string, Int32, Int32). In this task ResultSet = "Full result set" and Result Set > Result Name = 0, Variable Name = [User::viewInfo] which is a user variable with Data Type = Object.

I want to use a Foreach Loop Container to enumerate over the result set rows that are contained in the [User::viewInfo] variable described above. For each resultset row I want to breakout the 3 column values and assign them to 3 corresponding variables that can be referenced in a Data Flow in the Foreach Loop.

Current settings for the Foreach Loop Container: Collection > Enumerator = "Foreach ADO Enumerator", Collection > Enumerator Configuration > ADO object source variable = [User::viewInfo], Enumeration mode = "Rows in the first table". On the Variable Mappings page I select the 3 corresponding user variables I want the rowset column values assigned to, with indexes starting at 1 (not 0).

Thanks - Dana Reed

It sounds spot on to me Dana!

-Jamie

enumerate the rows of the xml

It is possible to enumerate the rows of the xml in a consultation?
For example:
select cast(tb01_XML as xml)
from Table01 as USU
where ID = 1
for xml raw(''), elements, type
<CAR xmlns="Hello" Name="Ricardo" />
<CAR xmlns="Hello" Name="Ricardo" />
-->
<CAR xmlns="Hello" Num="1" Name="Ricardo" />
<CAR xmlns="Hello" Num="2" Name="Ricardo" />
thank for any help
How exactly does your data look like?
You could use the ROW_NUMBER() function to add an enumeration...
Best regards
Michael
"sqlextreme" <sqlextreme@.discussions.microsoft.com> wrote in message
news:ABFC1DCD-1D33-4DBE-A606-68985452DE31@.microsoft.com...
> It is possible to enumerate the rows of the xml in a consultation?
> For example:
> select cast(tb01_XML as xml)
> from Table01 as USU
> where ID = 1
> for xml raw(''), elements, type
> <CAR xmlns="Hello" Name="Ricardo" />
> <CAR xmlns="Hello" Name="Ricardo" />
> -->
> <CAR xmlns="Hello" Num="1" Name="Ricardo" />
> <CAR xmlns="Hello" Num="2" Name="Ricardo" />
> thank for any help
>

enumerate the rows of the xml

It is possible to enumerate the rows of the xml in a consultation?
For example:
select cast(tb01_XML as xml)
from Table01 as USU
where ID = 1
for xml raw(''), elements, type
<CAR xmlns="Hello" Name="Ricardo" />
<CAR xmlns="Hello" Name="Ricardo" />
-->
<CAR xmlns="Hello" Num="1" Name="Ricardo" />
<CAR xmlns="Hello" Num="2" Name="Ricardo" />
thank for any helpHow exactly does your data look like?
You could use the ROW_NUMBER() function to add an enumeration...
Best regards
Michael
"sqlextreme" <sqlextreme@.discussions.microsoft.com> wrote in message
news:ABFC1DCD-1D33-4DBE-A606-68985452DE31@.microsoft.com...
> It is possible to enumerate the rows of the xml in a consultation?
> For example:
> select cast(tb01_XML as xml)
> from Table01 as USU
> where ID = 1
> for xml raw(''), elements, type
> <CAR xmlns="Hello" Name="Ricardo" />
> <CAR xmlns="Hello" Name="Ricardo" />
> -->
> <CAR xmlns="Hello" Num="1" Name="Ricardo" />
> <CAR xmlns="Hello" Num="2" Name="Ricardo" />
> thank for any help
>sql

EntMgr "Provider could not be found"

When doing open table-return rows - got the above
message... is this some sort of ODBC problem? thx
I'm having same problem,
"Shelley" wrote:

> When doing open table-return rows - got the above
> message... is this some sort of ODBC problem? thx
>
sql

EntMgr "Provider could not be found"

When doing open table-return rows - got the above
message... is this some sort of ODBC problem? thxI'm having same problem, :(
"Shelley" wrote:
> When doing open table-return rows - got the above
> message... is this some sort of ODBC problem? thx
>

Enterprise Manager Problem

Hi. I got Enterprise Manager to work finally.
However, the Columns are backwards when I retrieve all rows, and when i go
to design a table.
Meaning to say that the ID starts on right side of screen, and scrollbar is
on left side (everything is backwards)
in options of enterprise manager, it says english is default language.
thanksHi Michael,
Does this problem happen only with the Enterprise Manager or you see the
same behavior with , say Query Analyzer:
select * from pubs..authors where 1=2
How does the column order appear in the result window of this query ?
This may be more likely a language specific issue and I have seen certain
non-English languages (Arabic etc) which lay out the columns from
left-to-right.
So, you may want to review the configuration on the system, and spcifically
look for non-english related language choices during installation (both OS
and SQL related)
Hope this helps,
Ananth Padmanabham [MSFT]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply only to the newsgroups.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--
>From: "Michael" <Michael@.nospamplease.com>
>Subject: Enterprise Manager Problem
>Date: Fri, 12 Mar 2004 12:05:27 -0500
>Lines: 10
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <OFr$4QFCEHA.580@.TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: h-68-167-73-42.nycmny83.covad.net 68.167.73.42
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:333657
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi. I got Enterprise Manager to work finally.
>However, the Columns are backwards when I retrieve all rows, and when i go
>to design a table.
>Meaning to say that the ID starts on right side of screen, and scrollbar is
>on left side (everything is backwards)
>in options of enterprise manager, it says english is default language.
>thanks
>

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
>
>

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
>
>

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
> > >
> > >
> >
> >
>
>

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.

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:

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:
>

Enterprise Manager gets closed

Hi,
I am facing a problem in my SQl Server 7.0.
whenever i try to open a table in the Enterprise manager either for viewing
the All Rows or to edit the columns in the design view. Enterprise Manager
Get Closed without any warning. Although Everything seems fine when i try to
access the table from SQL Query Analyzer.
IS it a virus ?
Please advice...
Thanks and regards
jeetu
Can't ever rule out a virus, but is it one particular table or a particular database? Then run "DBCC CHECKDB('database')" and/or "DBCC CHECKTABLE ('table name')" on it.
I also can kill Enterprise Manager, for SQL Server 2000, and also Query Analyzer, by using the Fitaly on-screen keyboard program cursor key actions at the same time as the screen and Keystroke-reading Narrator. Are you using AN Assistive technology?
If EM is running on an NT family machine, is anything recorded in the Event Log? Perhaps if you switch on logging of application events? (Bear with me, the course was years ago.)

Enterprise Manager gets closed

Hi,
I am facing a problem in my SQl Server 7.0.
whenever i try to open a table in the Enterprise manager either for viewing
the All Rows or to edit the columns in the design view. Enterprise Manager
Get Closed without any warning. Although Everything seems fine when i try to
access the table from SQL Query Analyzer.
IS it a virus ?
Please advice...
Thanks and regards
jeetuCan't ever rule out a virus, but is it one particular table or a particular
database? Then run "DBCC CHECKDB('database')" and/or "DBCC CHECKTABLE ('tab
le name')" on it.
I also can kill Enterprise Manager, for SQL Server 2000, and also Query Anal
yzer, by using the Fitaly on-screen keyboard program cursor key actions at t
he same time as the screen and Keystroke-reading Narrator. Are you using AN
Assistive technology?
If EM is running on an NT family machine, is anything recorded in the Event
Log? Perhaps if you switch on logging of application events? (Bear with me,
the course was years ago.)

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 have a new Sony VAIO laptop and am running XP Pro sp2 and get the same error when trying to open a table in any database.
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 have a new Sony VAIO laptop and am running XP Pro sp2 and get the same error when trying to open a table in any database.
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 have a new Sony VAIO laptop and am running XP Pro sp2 and get the same error when trying to open a table in any database.

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 "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.
>