This works in 2000, shouldn't be hard to tweak for 2k5.

SELECT Name, OBJECTPROPERTY(id, 'IsDeterministic') AS isDeterministic FROM dbo.SysObjects WHERE XType = 'FN' ORDER BY OBJECTPROPERTY(id, 'IsDeterministic') DESC, Name

How about you search how to make a trigger work on a set of rows.  I'm sure that this come in handy someday!!

I think that she needs help on the fact that building a single index on a very large table takes a lot of time VS a course on why to...

I meant with more than 1 row inserted at the same time.

So what happens when more than 1 row is inserted in the table?

I c, I misread the question.

This will get you started in the right direction :

SELECT * FROM dbo.SysColumns C INNER JOIN dbo.SysObjects O ON C.cDefault = O.id

You need to know what will be the default for each datatype.  But the real question is why do you need to do this?

My first and only question is why do you want to do that for?

I was reffering to something like the auto-close option.  Where it gets opened when needed, but I haven't been able to find a way to do something like this... anyone...

How about closing all the databases.  Come back a while later.  If the db is on then it's used by someone.

That's not what I meant.  I mean network traffic where application like EM or SSIS checks to see if the server is still online.  That can be one cause of your...

Do you have a lot of noise on the netwrok traffic on 2005 compared to 2000?

Are any of the databases using autoclose or autoshrink?

The only solution I can come up with is to hardcode the default value in the insert (which defeats the purpuse of having the default on the column).

You could also...

If you want the default to be used you have to leave the column out of the insert.  I have little experience in large system designed like this so I'll...