Can I assume that none of these users is a member of any server role and that their access is via membership in the public database role?  You may want...

Try:

DECLARE @month int, @year int

SELECT @month = 6, @year = 2004

SELECT DATEPART(dd,DATEADD(m,1,CAST(STR(@month) + '/01/' + STR(@year) as datetime)) - 1)

You supply the month and year.  The select...

If you don't specifically order by some column there is no guarantee that select statements will return results sets ordered by that column.  In other words the ONLY way to...

If you use the money type you should not prevent the hundredths/thousandths from being stored.  These decimal places are for arithmetic precision.  If you need to multiply/divide your money you may...

I would use the money type.  But then I would be probably using .net which supports the money type via its currency data type.  If you are using C++ or...

Do not attempt to transfer any of the system databases (master, msdb, temp or model.)  These will all be created for you when you install SQL 2000.  You may need...

A SQL 7 backup can be restored in SQL 2000 so this is an easy method of copying the databases from one server to another.  

To transfer logins and passwords from...

I agree with Gabor 2G is high for the OS.  500 M is good enough.  But aside from that check out http://www.sql-server-performance.com/performance_monitor_counters_memory.asp for some ideas on memory counters in Perfmon.

Your correct.  Like %xxxx% will retrun all rows with xxxx in that column regardless of where in that column its found.

try:

DELETE from Table1 t

WHERE  Statdate != (SELECT MAX(Statdate) FROM Table1 t1

 WHERE t.ServerName = t1.ServerName 

 AND CONVERT(VARCHAR(10),t.Statdate ,103)  = CONVERT(VARCHAR(10),t1.Statdate ,103))

Lots can go wrong with adding an attachment, the file is missing, in use etc.  Try putting some error check to find out what happened.  Example:

EXEC @iHr = sp_OAMethod @oMail,...

AS you said use INSTEAD OF trigger but use the UPPER function.  You do not edit the Inserted table you just insert the UPPER of the values as in:

CREATE TRIGGER...

Use the UPPER function.

In a production environment all objects are likely (and probably should be) owned by dbo.  If you don't say SQL Server checks for objects owned by the logged in user...

I guess I am thinking about ASP. 

In this case they are using the MS JDBC driver.  After I read your reply I looked up some info on JDBC and...