Take a look at "FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4"

http://support.microsoft.com/kb/899761

"is it possible to access Windows Event Viewer from SQL?"

Not directly, but the Log Parser utility can be used to load the windows event log into a SQL Server table....

"f I am understanding what you wrote then the solution is truly laughable from a performance (and coding) standpoint!! You have to create two tables and populate them both row-by-row...

"5. Just TRY to write a set based trigger in Oracle... just go ahead and try!" This can be done.

1. For the triggering table, create two temporary tables,...

Here some SQL to list all of the database properties:

selectCAST( SERVERPROPERTY ('MachineName') as nvarchar(128) )AS MachineName

,COALESCE ( CAST( SERVERPROPERTY ('InstanceName') as nvarchar(128) ) , 'Default')AS InstanceName

,db.name as DatabaseName

,db.crdateas CreateTs

,db.sidas...

Under SQL Server 2000 32 bit with AWE enable, memory is not managed dynamically, so under your specifications of max server memory of 15Gb, at start-up SQL Server will obtain...

Your example SQL is exactly the case where a table would be superior to a stored procedure. With a table, the values of the date range are visible to...

For a calendar, there are two alternative solutions of creating a table or using a function.

As the SQL Query optimizer can make use of table indicies, constraints and statistics but...

FYI: SQL Server 2008 SSMS starts much faster than 2005. An initial open takes about 9 seconds versus about 45 seconds for SSMS 2005 and a second open about...

I am not having a problem and here is test case.

select database_id,name

from master.sys.databases

wheredatabase_id <= 5

FOR XML AUTO, ELEMENTS, ROOT('databases')

The "ROOT" keyword is only available with the "RAW" option and is not available with the "AUTO" option.

Try the "dBase File" ODBC driver.

4 to 6 weeks !!? In Chicago, I typically get 3 offers in the first week I am looking at $65 an hour. Have a colleague with a...

Task Manager does not provide accurate memory usage information for AWE. System Monitor should be used instead.

http://msdn2.microsoft.com/en-us/library/aa213764(sql.80).aspx

Process explorer can show more information as is available at http://www.microsoft.com/technet/sysinternals/default.mspx

The ISO SQL standards has, amoung others, these trigger options:

1. "Before", "After" and "Instead"

2. "for each statement" and "for each row"

3. firing order

SQL Server 2000 supports:

1. ...