Re: Connection Logs in SQL Server

Here are a couple resources (SQL Server 2000 specific):
http://www.sqlservercentral.com/articles/Administering/auditingwithsqlprofiler/1461/
http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

Using server side traces is a good way for production environments:
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
http://www.dbazine.com/sql/sql-articles/larsen6

This one is SQL Server 2005 specific:
http://blogs.msdn.com/sqlprogrammability/archive/2006/08/16/703079.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com

.

Relevant Pages

  • Re: SP3a on cluster...help please
    ... If you have all nodes online, the SP install will work 'cluster-wide' on all ... remember to start the service pack from the node that currently owns the SQL ... I support the Professional Association for SQL Server ... > "While performing the cluster portion of SQL Server 2000> SP3 or SP3a, the setup will reset all cluster resources to> the default properties for all resources in the group,> whether they are related to SQL Server or not." ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBSMonitoring and Sharepoint DB Movement
    ... Installing a ful blown version of SQL server will not neecssarilly save more ... resources than taking the approach mentioned above. ... Sql Server/MSDE instances on SBS: ... sbsmonitoring/sharepoint databases that are installed by default in SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: How to remove (uninstall ) cluster sql server manually
    ... just keep the group and the disk resource. ... Do i need to delete sql group also to clean the sql server? ... check out www.clusterhelp.com for suitable training in clusters. ... I did not delete any resources in cluadmin. ...
    (microsoft.public.sqlserver.clustering)
  • SQL Server 2000 Cluster Manual Failover
    ... I have a two-node SQL Server 2000 cluster running on Windows 2003 SP1. ... cluster resources set up in 4 groups. ... I've noticed that if I try to manually fail over one of the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to remove (uninstall ) cluster sql server manually
    ... SQL Server MVP ... I have deleted cluster resources as you said. ...
    (microsoft.public.sqlserver.clustering)