Are there any jobs that run during that time such as application jobs, tape backups, database backups, reindex or checkdb ?

Were you aware that if a SQL statement uses functions, indexes may not be used ? This can have an adverse performance effect.

Could an outer join be the solution...

Try

select DATABASEPROPERTYEX('MyDatabase','Collation') as DB_Collation, SERVERPROPERTY('Collation') as Server_Collation

Could this be caused by Windows Regional Settings ?

Please post a follow-up when you find the cause.

Thanks for the posting. As a contractor, I run into a lot of strange configuration but this one is certainly "one for the books".

Since tempdb is recreated from the...

Here is a simplier solution:

create trigger ti_table1 on table1 for insert

as

set nocount on

set xact_abort on

-- if an insert was performed but no rows where inserted, then exit.

IF @@rowcount =...

The previously provided solution will not work as it will return multiple rows when there is more than one row for the same productNo and location.

ProductNo Location Date

1234 ...

The posted CHECKDB output is missing some of the system tables for SQL Server 2000 including sysindexkeys, sysconstraints, sysdepends, sysprotects and sysforeignkeys.

Check to see if these table exist within...

From your original post, slightly re-organized.

With a number stored as a character column, the risk of introducing a fatal bug is close to 100%. Strongly recommend changing the datatype.

I...

Number off error logs is in the registry

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

in NumErrorlogs

exec master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorlogs', REG_DWORD, 13

Regarding your current server and performance statistics

Has anyone looked at the network ? Try capturing #packets in/out and packet errors.

To check if the application is chatty, capture SQL...

Can the rows for Users and Hosts be added to the Roles table ?

If not:

SELECT s.valor, r.rolename as description

FROM Split( '14;0;-1;-2;', ';' ) s

LEFT OUTER JOIN

(select role_id, rolename

from...

What is the datatype for "INTERVAL_DATE" of colummn "during"?

What is function dbo.intersects ?

Just curious

What do you mean by an Security Auditing solution ?

Some possibilites include:

Process and procedures to managing SQL Server Security rights such as creating logins, changing passwords, granting roles, etc.

Tracking security...

This not possible.

You cannot concatenate two NVarChar(4000) into a single NVarchar(4000)

You also cannot put 2 liters into a 1 liter container (or 2 gallons into a 1 gallon container)

In the future, please post "CREATE TABLE" and Insert statments, not the output of a select.

There are a number of problems with your SQL:

1. Based the example tables and...