SQL Profiler would be ideal to monitor any activities on SQL Server.

Is this what you are looking for?

SELECT DISTINCT parent_product, sub product, descrip

FROM TABLENAME

WHERE CONVERT(VARCHAR(10),DATE,111)=(SELECT MAX(DATE)FROM TABLENAME)

I might have misread your query. You can grant access to a user to a specific database and he will not be able to access other databases available in that...

If you are validating the CD column with the help of Eff Date and End Date, then in the INSERT trigger a query with "Where" clause can help you out.

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 !