How Do I Get SQL Server 2000 Reboot Time

I'd like to report to the user when the server was most recently
rebooted.
Is there a stored procedure or SQL Server 2000 command that I can issue?you can use this script here from www.insidesql.de:
SELECT
DATEDIFF(hh,crdate,GETDATE()) AS UpTimeInStunden
FROM
master.dbo.SYSDATABASES
WHERE
Name = 'TempDB'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi,
no need to multipost, asnwered in .sqlserver.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Just use the SystemInfo.exe commandline tool.
<BillJohnson4@.gmail.com> wrote in message
news:1145643233.124362.207240@.i39g2000cwa.googlegroups.com...
> I'd like to report to the user when the server was most recently
> rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
>|||> I'd like to report to the user when the server was most recently rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
SELECT login_time FROM master.dbo.sysprocesses WHERE spid=1

How Do I Get SQL Server 2000 Reboot Time

I'd like to report to the user when the server was most recently
rebooted.
Is there a stored procedure or SQL Server 2000 command that I can issue?you can use this script here from www.insidesql.de:
SELECT
DATEDIFF(hh,crdate,GETDATE()) AS UpTimeInStunden
FROM
master.dbo.SYSDATABASES
WHERE
Name = 'TempDB'
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi,
no need to multipost, asnwered in .sqlserver.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Just use the SystemInfo.exe commandline tool.
<BillJohnson4@.gmail.com> wrote in message
news:1145643233.124362.207240@.i39g2000cwa.googlegroups.com...
> I'd like to report to the user when the server was most recently
> rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
>|||> I'd like to report to the user when the server was most recently rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
SELECT login_time FROM master.dbo.sysprocesses WHERE spid=1

How do I find out which DB have the Guest account on them

How do I find out which DB's have the Guest account on them?
Also do you know if SP4 requires a reboot of the system?
Jim Abel wrote:
> How do I find out which DB's have the Guest account on them?
> Also do you know if SP4 requires a reboot of the system?
You can run sp_helplogins. For example:
Exec sp_helplogins 'DOMAIN\USER_NAME'
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yes, SP4 requires a reboot.
"Jim Abel" wrote:

> How do I find out which DB's have the Guest account on them?
> Also do you know if SP4 requires a reboot of the system?

How do I find out which DB have the Guest account on them

How do I find out which DB's have the Guest account on them?
Also do you know if SP4 requires a reboot of the system?Jim Abel wrote:
> How do I find out which DB's have the Guest account on them?
> Also do you know if SP4 requires a reboot of the system?
You can run sp_helplogins. For example:
Exec sp_helplogins 'DOMAIN\USER_NAME'
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, SP4 requires a reboot.
"Jim Abel" wrote:

> How do I find out which DB's have the Guest account on them?
> Also do you know if SP4 requires a reboot of the system?

How do I find out which DB have the Guest account on them

How do I find out which DB's have the Guest account on them?
Also do you know if SP4 requires a reboot of the system?Jim Abel wrote:
> How do I find out which DB's have the Guest account on them?
> Also do you know if SP4 requires a reboot of the system?
You can run sp_helplogins. For example:
Exec sp_helplogins 'DOMAIN\USER_NAME'
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yes, SP4 requires a reboot.
"Jim Abel" wrote:
> How do I find out which DB's have the Guest account on them?
> Also do you know if SP4 requires a reboot of the system?