EnterpriseManager-->Process Info Screen

SQL 2000 SP3
================================================

In reviewing this screen, I have SPIDS > 100 that have a status of
sleeping, command = AWAITING COMMAND and login/batch dates that are
weeks old ... Shouldn't this list be more recent activity only ?

Thanks,

Craig(csomberg@.dwr.com) writes:
> SQL 2000 SP3
>================================================
> In reviewing this screen, I have SPIDS > 100 that have a status of
> sleeping, command = AWAITING COMMAND and login/batch dates that are
> weeks old ... Shouldn't this list be more recent activity only ?

I guess that depends on what you expect on your site. If you have
developers who connect through Query Analyzer every once in a fortnight,
this is would display like this.

I don't know if that screen shows application, hostname and that, but
you can use sp_who2 or query sysprocesses directly to get this information.
This can give you an idea whether this is normal, or if something is
fishy.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

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

Enterprise Manager Under XP

Just installed SQL on an XP client (my workstation). When I run enterprise manager, I have found that I no longer have toolbars (command bars) in the child windows (i.e. design table, open table, etc.). The toolbar buttons appear in the main window but not in the child window. This only appears to happen with XP (not in 2000). A buddy of mine is having the same issue.

Anybody know how to get my child window toolbars back? Thanks...Originally posted by pate
Just installed SQL on an XP client (my workstation). When I run enterprise manager, I have found that I no longer have toolbars (command bars) in the child windows (i.e. design table, open table, etc.). The toolbar buttons appear in the main window but not in the child window. This only appears to happen with XP (not in 2000). A buddy of mine is having the same issue.

Anybody know how to get my child window toolbars back? Thanks...

Menu>VIEW>CUSTOMIZE

??|||Originally posted by Brett Kaiser
Menu>VIEW>CUSTOMIZE

??

Been there and tried every possible option available without any luck...|||Originally posted by pate
Just installed SQL on an XP client (my workstation). When I run enterprise manager, I have found that I no longer have toolbars (command bars) in the child windows (i.e. design table, open table, etc.). The toolbar buttons appear in the main window but not in the child window. This only appears to happen with XP (not in 2000). A buddy of mine is having the same issue.

Anybody know how to get my child window toolbars back? Thanks...

I never did like xp...why that platform?

Enter Today's Date in SSMS Open Table Grid View

What date constants are available for entering today's date in a
datetime column after using the Open Table command within SSMS? I
have tried GETDATE() and CURRENT_TIMESTAMP, but neither worked.
Another question - if I open the samed named table in two databases to
compare the data contents using Open Table, the tab labels only
display the table name and are not fully qualified. Is there an SSMS
option to show the table labels fully qualified.
Thanks in advance - Peter
pwc (pcrickman@.verizon.net) writes:
> What date constants are available for entering today's date in a
> datetime column after using the Open Table command within SSMS? I
> have tried GETDATE() and CURRENT_TIMESTAMP, but neither worked.
You look at your watch, and the type what you see. Open Table is a very
simple data-entry tool.
If you don't want to consult your watch, you will have to write an INSERT
or an UPDATE statement instead.

> Another question - if I open the samed named table in two databases to
> compare the data contents using Open Table, the tab labels only
> display the table name and are not fully qualified. Is there an SSMS
> option to show the table labels fully qualified.
Yes, it's called SP2. That is, they've changed this in SP2 so that the
database name is included.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx