You may pick the counters as per your requirement from the below URL

http://msdn2.microsoft.com/en-us/library/ms190382.aspx

The following command in cmd give the desired result.

OSQL -L (SQL Server 2000)

SQLCMD -L (SQL Server 2005)

According to me you can only defragment the fragmented indexes.

As usual go to Add/Remove programs and Remove SQL Server. In the un-installation screen select the Instance that you want to remove.

This site might be of use to you.

http://msdn2.microsoft.com/en-us/express/aa718391.aspx

Yes. You need to be a member of the Local Administrators group to install SQL Server 2005. More details can be found at

http://technet.microsoft.com/en-us/library/ms143219.aspx

See the below link in BOL for more information.

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\vdtsql.chm::/dvhowmodifyingcheckconstraint.htm

I would suggest monitoring the following counters.

Processor:% Processor Time

PhysicalDisk:Avg.Disk Queue Length

PhysicalDisk:Disk Read Bytes/sec and PhysicalDisk :Disk Write Bytes/sec

Thanks Scott. Even I checked the security log, still could not figure out. I am just wondering is there any better way to find this out.

The Stored procedure which is already available on this site might serve your purpose.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

You can open multiple Database connections in a procedure.

Example

Dim Cn as OneConnection

Cn.connectionstring=..........

Dim Cn2 as SecondConnection

Cn2.ConnectionString

Cn.execute Qry

Cn2.execute qry.

With this you can use multiple database without creating ODBC Connections !

Your statement is a bit confusing. Do you time out when the databases are on the same server or on different servers?

If you are taking care of "Displaying" the result set, try using CONVERT.

http://msdn2.microsoft.com/en-us/library/ms187928.aspx

Use the Convert function while inserting date and time. This will hep.

http://msdn2.microsoft.com/en-us/library/ms187928.aspx

Yes.. Even I feel you should go for a Trigger.