Try doing these

First:

In database property set query time out to 0, It's default vaule is 600.

I do not think there is anything like that.

In general at server side there is...

Gail, what about query wait. I quote from BOL:

Query Wait

Specifies the time in seconds (from 0 through 2147483647) that a query waits for resources before timing out. If the default...

You should not change password thru services.msc. Instead you should change it thru sql server configuration manager.

-------------

depends

we have a 64bit SQL server that threw up some errors and turned out to be memory and SQL grabbing too much. had to put a max memory figure and...

Jonathan thank you for confirmation and explanation.

Memtoleave has no effect on 64 bit instance. On my instance with 64 GB memory, I ran into VAS fragmentation few times in the past.

I do not think it would be a concern for 64 bit sql instance. Correct me if I am wrong.

I saw my tempdb tlog displayed like that.

as long as they are active/passive nodes, you can power down the passive, do the expansion online using diskpart after your san admin expands the drives.

just curious how to reset the new default for udf length.

i guess that in sql 2000, you need to make sure the user has select permission on underly table if it belongs to different user.

after dettach and attach db, even in same instance, you need to reenable cross-db ownership chaining.

yes i am interested.

Yes. I am interested.

Pls keep us posted. Thx.