How long register the Databases without access?

Hi Friends...
I want to know if exist a possibility to check who was the last user in
acceding some databases, and how time passed after it.
I need to know this, because i have more than 100 databases on a clustered
server and i supposed that more than 20 are unused.
Thanks all!
Hi
Not possible unless you switch on extensive auditing like C2 in SQL Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:15369103-F255-402F-A148-FEA183AEA2D3@.microsoft.com...
> Hi Friends...
>
> I want to know if exist a possibility to check who was the last user in
> acceding some databases, and how time passed after it.
> I need to know this, because i have more than 100 databases on a clustered
> server and i supposed that more than 20 are unused.
> Thanks all!
>

How long register the Databases without access?

Hi Friends...
I want to know if exist a possibility to check who was the last user in
acceding some databases, and how time passed after it.
I need to know this, because i have more than 100 databases on a clustered
server and i supposed that more than 20 are unused.
Thanks all!Hi
Not possible unless you switch on extensive auditing like C2 in SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:15369103-F255-402F-A148-FEA183AEA2D3@.microsoft.com...
> Hi Friends...
>
> I want to know if exist a possibility to check who was the last user in
> acceding some databases, and how time passed after it.
> I need to know this, because i have more than 100 databases on a clustered
> server and i supposed that more than 20 are unused.
> Thanks all!
>

How long register the Databases without access?

Hi Friends...
I want to know if exist a possibility to check who was the last user in
acceding some databases, and how time passed after it.
I need to know this, because i have more than 100 databases on a clustered
server and i supposed that more than 20 are unused.
Thanks all!Hi
Not possible unless you switch on extensive auditing like C2 in SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:15369103-F255-402F-A148-FEA183AEA2D3@.microsoft.com...
> Hi Friends...
>
> I want to know if exist a possibility to check who was the last user in
> acceding some databases, and how time passed after it.
> I need to know this, because i have more than 100 databases on a clustered
> server and i supposed that more than 20 are unused.
> Thanks all!
>

How I can register MSSQL Server 2000 by IP Address

How I can register MSSQL Server 2000 by IP Address-

I installed MSSQL Server 2000 sp3a, Enterprise edition on windows 2000 advanced server box with sp4. Its primarily give instance with name like servername/sqlindia, Where sqlindia is instance and servername is physical machine name.

I would like to registration of sqlserver instance by IP Address. How I can do it.

Thanking You

R.MallEnsure the client network utility is mentioned with ALIAS using IP Address.