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
>

Enterprise Manager results timeout

Hi -
Often when working on a query or viewing a table in Enterprise Manager, I ge
t messages such as "There has been no recent activity in the results pane" a
nd threatening to clear it. Is there any way to get rid of these messages? I
'm capable of determining w
hen too many resources are in use on the server without the help of these me
ssages.
Thanks,
JimNo...other than using Query Analyzer instead.
The behavior is by design. The following article applies to
SQL Server 2000 as well:
PRB: Table Designer Automatically Clears Results Pane When
Idle
http://support.microsoft.com/?id=252434
-Sue
On Wed, 10 Mar 2004 08:46:23 -0800, "Jim S"
<anonymous@.discussions.microsoft.com> wrote:

>Hi -
>Often when working on a query or viewing a table in Enterprise Manager, I get messa
ges such as "There has been no recent activity in the results pane" and threatening
to clear it. Is there any way to get rid of these messages? I'm capable of determini
ng
when too many resources are in use on the server without the help of these messages.darkred">
>Thanks,
>Jim|||Hi Jim.
We share in your frustration. Have you come up with any solutions yet?
-Dan
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Enterprise Manager Create Date

Folks,
When viewing the tables of the databases we have on our Server, the
values in the "Create Date" column are generally of the format
"DD/MM/YYYY HH:MM:SS". Curiously however, I just had to recreate one
of the tables, and on that table alone the create date displayed is
"YYYY-MM-DD HH:MM:SS.FFF" (FFF = fractions of a second I assume?)
Anyone know why this has changed? Could it be some kind of change of
regional settings on the Server?
Suggestions invited
Thanks
SteveSteve Hall wrote:
> Folks,
> When viewing the tables of the databases we have on our Server, the
> values in the "Create Date" column are generally of the format
> "DD/MM/YYYY HH:MM:SS". Curiously however, I just had to recreate one
> of the tables, and on that table alone the create date displayed is
> "YYYY-MM-DD HH:MM:SS.FFF" (FFF = fractions of a second I assume?)
> Anyone know why this has changed? Could it be some kind of change of
> regional settings on the Server?
See if it helps you:
Solving the Datetime Mystery (SQL Server Magazine)
http://www.winnetmag.com/SQLServer/.../9147/9147.html
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Sebastian K. Zaklada" <szaklada-dont-like-spam@.skilledsoftware.com> wrote in message news:
<OoKQfbfBEHA.2804@.tk2msftngp13.phx.gbl>...
> Steve Hall wrote:
> See if it helps you:
> Solving the Datetime Mystery (SQL Server Magazine)
> http://www.winnetmag.com/SQLServer/.../9147/9147.html
> sincerely,
Sebastian,
Thanks for that... but I think I may be missing something still - that
information suggests how I can format dates returned from queries...
But this is the table's create date property - internal to SQL - where
is that format defined?
Forgive me if I am still missing your point!
Steve

Enterprise Manager and Master/temdb viewing

Hello,
Sorry for the simple question I am about to ask however I have not
found the answer elsewhere.
We have installed an SQL 200 box and are now about to grant users
access via Enterprise Manager. We have created logins for each user
with no Server Roles and access to their DB only. However when we
connect as this user through EM we can see Master and tempdb and view
the table information associated with theses DB's. We have removed
'guest' access from all other DB's. Is there any way to disable users
abilities to view the tempdb and master databases?
Thanks for your help.
CHi
Not with SQL Server 2000. This limitation is addressed in SQL Server 2005.
Everyone has rights to read sysdatabases and sysobjects.
Regards
Mike
"gg" wrote:
> Hello,
> Sorry for the simple question I am about to ask however I have not
> found the answer elsewhere.
> We have installed an SQL 200 box and are now about to grant users
> access via Enterprise Manager. We have created logins for each user
> with no Server Roles and access to their DB only. However when we
> connect as this user through EM we can see Master and tempdb and view
> the table information associated with theses DB's. We have removed
> 'guest' access from all other DB's. Is there any way to disable users
> abilities to view the tempdb and master databases?
> Thanks for your help.
> C
>|||Hi gg,
One of the thing you can do is, on the client machine, while you register
SQL server through EM, in the properties you can uncheck "Show system
database and system objects". This will prevent the client user from seeing
system database.
--
Thanks
Yogish

Enterprise Manager and Master/temdb viewing

Hello,
Sorry for the simple question I am about to ask however I have not
found the answer elsewhere.
We have installed an SQL 200 box and are now about to grant users
access via Enterprise Manager. We have created logins for each user
with no Server Roles and access to their DB only. However when we
connect as this user through EM we can see Master and tempdb and view
the table information associated with theses DB's. We have removed
'guest' access from all other DB's. Is there any way to disable users
abilities to view the tempdb and master databases?
Thanks for your help.
C
Hi
Not with SQL Server 2000. This limitation is addressed in SQL Server 2005.
Everyone has rights to read sysdatabases and sysobjects.
Regards
Mike
"gg" wrote:

> Hello,
> Sorry for the simple question I am about to ask however I have not
> found the answer elsewhere.
> We have installed an SQL 200 box and are now about to grant users
> access via Enterprise Manager. We have created logins for each user
> with no Server Roles and access to their DB only. However when we
> connect as this user through EM we can see Master and tempdb and view
> the table information associated with theses DB's. We have removed
> 'guest' access from all other DB's. Is there any way to disable users
> abilities to view the tempdb and master databases?
> Thanks for your help.
> C
>
|||Hi gg,
One of the thing you can do is, on the client machine, while you register
SQL server through EM, in the properties you can uncheck "Show system
database and system objects". This will prevent the client user from seeing
system database.
Thanks
Yogish

Enterprise Manager and Master/temdb viewing

Hello,
Sorry for the simple question I am about to ask however I have not
found the answer elsewhere.
We have installed an SQL 200 box and are now about to grant users
access via Enterprise Manager. We have created logins for each user
with no Server Roles and access to their DB only. However when we
connect as this user through EM we can see Master and tempdb and view
the table information associated with theses DB's. We have removed
'guest' access from all other DB's. Is there any way to disable users
abilities to view the tempdb and master databases?
Thanks for your help.
CHi
Not with SQL Server 2000. This limitation is addressed in SQL Server 2005.
Everyone has rights to read sysdatabases and sysobjects.
Regards
Mike
"gg" wrote:

> Hello,
> Sorry for the simple question I am about to ask however I have not
> found the answer elsewhere.
> We have installed an SQL 200 box and are now about to grant users
> access via Enterprise Manager. We have created logins for each user
> with no Server Roles and access to their DB only. However when we
> connect as this user through EM we can see Master and tempdb and view
> the table information associated with theses DB's. We have removed
> 'guest' access from all other DB's. Is there any way to disable users
> abilities to view the tempdb and master databases?
> Thanks for your help.
> C
>|||Hi gg,
One of the thing you can do is, on the client machine, while you register
SQL server through EM, in the properties you can uncheck "Show system
database and system objects". This will prevent the client user from seeing
system database.
Thanks
Yogish