|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > Return all rows shows no data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Return all rows shows no data
|
|
|
|
I have a perplexing problem with SQL 7 Sp2. When I rightclick on "open
table>>>>return all rows" on any database table including master, the
table view opens fine, however there is no data at all. Also there are
no gridlines, columm names etc. The menu bars and asscoiated icons are
present, however there is no action from them when clicking on them.
I am logged onto as administrator and using the default SA SQL logon on
WinNt 4.0. Using query analzyer shows all the data in the database.
IThinking it maybe a permissions related, I created a new user with full
permissions, this did not make any difference.
This issue was not preceeded by any changes to the pc, or sql itself, we
have had no reason to make any changes to the pc or sql.
I have reinstalled SQL Server SP2, IE 6.0, NT SP6A and still no go.
Any advice would be much appreciated.
--
Regards,
Mark
| |
| BP Margolin 2002-08-03, 3:23 pm |
| Mark,
The problem lies within the client application (Enterprise Manager), not the
SQL Server instance ... that's clearly demonstrated by the fact that Query
Analyzer returns the data correctly. So re-installing the server software is
"attacking" the problem at the wrong place. Try re-installing Enterprise
Manager on the workstation.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"mark" <mw@nospam.com> wrote in message
news:MPG.17b5de5178a7c2689896ba@24.69.255.211...
>
> I have a perplexing problem with SQL 7 Sp2. When I rightclick on "open
> table>>>>return all rows" on any database table including master, the
> table view opens fine, however there is no data at all. Also there are
> no gridlines, columm names etc. The menu bars and asscoiated icons are
> present, however there is no action from them when clicking on them.
>
> I am logged onto as administrator and using the default SA SQL logon on
> WinNt 4.0. Using query analzyer shows all the data in the database.
> IThinking it maybe a permissions related, I created a new user with full
> permissions, this did not make any difference.
>
> This issue was not preceeded by any changes to the pc, or sql itself, we
> have had no reason to make any changes to the pc or sql.
>
> I have reinstalled SQL Server SP2, IE 6.0, NT SP6A and still no go.
>
> Any advice would be much appreciated.
>
> --
> Regards,
> Mark
| |
|
| In article <##4Xq5yOCHA.1636@tkmsftngp13>, bpmargo@attglobal.net says...
> Mark,
>
> The problem lies within the client application (Enterprise Manager), not the
> SQL Server instance ... that's clearly demonstrated by the fact that Query
> Analyzer returns the data correctly. So re-installing the server software is
> "attacking" the problem at the wrong place. Try re-installing Enterprise
> Manager on the workstation.
>
> -------------------------------------------
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.
>
> "mark" <mw@nospam.com> wrote in message
> news:MPG.17b5de5178a7c2689896ba@24.69.255.211...
> >
> > I have a perplexing problem with SQL 7 Sp2. When I rightclick on "open
> > table>>>>return all rows" on any database table including master, the
> > table view opens fine, however there is no data at all. Also there are
> > no gridlines, columm names etc. The menu bars and asscoiated icons are
> > present, however there is no action from them when clicking on them.
> >
> > I am logged onto as administrator and using the default SA SQL logon on
> > WinNt 4.0. Using query analzyer shows all the data in the database.
> > IThinking it maybe a permissions related, I created a new user with full
> > permissions, this did not make any difference.
> >
> > This issue was not preceeded by any changes to the pc, or sql itself, we
> > have had no reason to make any changes to the pc or sql.
> >
> > I have reinstalled SQL Server SP2, IE 6.0, NT SP6A and still no go.
> >
> > Any advice would be much appreciated.
Thanks for the help BP, that did the trick!!
--
Regards,
Mark
|
|
|
|
|