If you don't specify a time, it defaults to 12:00:00.

I suspect your entries for 8/31/2003 will have a time later than 12:00:00.

Change your query to between '8/1/2003 00:00:00' and 8/31/2003...

The syntax of your select statement looks a little strange. I presume this is just a typo?

Do you check the value of @@rowcount at the start of the trigger?

If the...

Have you tried all of this using the account that SQL Server starts up as?

Also, if SQL Server starts up as the LocalSystem account, it will have no network access.

...

With your configuration, you should also set the /3gb switch in boot.ini.

If you allocate 6gb as in your example, you aren't leaving much memory for the other 2 instances that...

You could write a UDF that returns a table with one row for each date in the period, and then left join your invoices table to the UDF

e.g. the function...

Just to add my twopenny worth:-

SELECT ServerId, JobName, MAX(ProcDate)

FROM DisjObEvt

GROUP BY ServerId, JobName, convert(varchar(255),procdate,106)

Thanks mbroodbakker, I hadn't come across dbcc iotrace before, so I'll give that a go.

ALTER VIEW, CREATE VIEW and a whole host of other statements must be the only statements in a batch. Try this instead:-

if exists (select * from sysobjects where type =...

Microsoft's own clustering software just executes 'SELECT @@SERVERNAME' to see if an instance is alive.

I've always used the logical reads from statistics IO in the past, and found it very consistent. Unfortunately, it doesn't show writes.

I had also tried fn_virtualfilestats on my development workstation...

If you do get any more information from Kalen, please post it. I'm trying to make use of fn_get_sql in some production monitoring.

Thanks

Displaying results in text or a grid is a 'client thing', and nothing to do with the server part of SQL Server.

As far as I know, the only way is...

How long is a piece of string?

You need to do a proper sizing exercise.

If you have a lot of static data i.e. very few changes, then a comparatively small log...

If you put the date in the format yyyymmdd i.e. no separators between the various bits of the date, then SQL Server will correctly interpret the date regardless of regional...

That column isn't a datetime data type, it is an integer. If the job hasn't run, the column is zero, rather than a date, and therefore conversion fails.

With the last_run_duration...