In your case:

If there is only ONE .ldf on the log drive, I'll put tempdb log AND data file on the data drive.

If there is more than one .ldf on...

watch out that the SUM doesn't overflow the field definition.

take this simple example:

field defined as decimal(3, 2)

with values:

1.01

6.00

4.00

Summing these would produce 11.01, thus an overflow.

So u may need to cast...

where isnumeric(fieldname) = 1

and convert(int, fieldname) < 1

database_id <= 4 is system db.

databse_id > 4 is user db

or... if name is

Master

Msdb

Tempdb

Model

Then its system db

SQL 2005 SE can use as much memory as OS supports.

for more than 4Gb I'll use /3gb and enable AWE, Lock pages in memory

on your 2000 SE instance don't do...

James L Kerr (10/25/2007)

---

I don't believe that is the issue, becuase if you needed the SQL Server/Agent Service Domain account in the local admin role, the installation would have placed...