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 Mgr Can Not Sort?

Why can I not sort my stored procedure listing by creation date?

I am seeing these dates (omitted the time as not relevant)

2004-03-06
2004-05-14
2004-05-18
2004-03-06

After clicking the 'Create Date' header.

What gives??Brian (bonei@.vafb.com) writes:
> Why can I not sort my stored procedure listing by creation date?
> I am seeing these dates (omitted the time as not relevant)
> 2004-03-06
> 2004-05-14
> 2004-05-18
> 2004-03-06
> After clicking the 'Create Date' header.
> What gives??

I vaguely recall having seen incorrect date formatting in Enterprise
Manager before, although I think that was the Jobs listing. Looking
now, I cannot see anything funny. Maybe there was a bug that was fixed
in a service pack? I'm running SP3, and you? Then again, regional
settings may also matter.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Enterprise Manager, table CreateDate doesn't sort correctly

In EM, when viewing the tables in a database, the tables do not sort
correctly by CreateDate when you click the header. However, in other
databases on the same server, it sorts correctly. Odd.
The only subtle difference we've found is that those databases where the
table create date displays with AM or PM sorts correctly. Those that
display the millisecond in the Create Date do not sort correctly?
Any ideas on how to solve this problem? Thanks in advance!
Mark
SQL Server 2000 with latest and greatest service packs> In EM, when viewing the tables in a database, the tables do not sort
> correctly by CreateDate when you click the header. However, in other
> databases on the same server, it sorts correctly. Odd.
I've seen this too, and can't explain it (nor do I know the fix). I'd show
you the article on my site, but a middleman provider is having issues.
If you really need this functionality, run a query from sysobjects WHERE
xtype='U' ORDER BY crdate DESC...
--
Aaron Bertrand
SQL Server MVP
> The only subtle difference we've found is that those databases where the
> table create date displays with AM or PM sorts correctly. Those that
> display the millisecond in the Create Date do not sort correctly?
> Any ideas on how to solve this problem? Thanks in advance!
> Mark
> SQL Server 2000 with latest and greatest service packs
>