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...

I just have one question. Are Dinekar contributions any less to the community because he asked for a link for something that was already offered to him in the past?  I...

Nothing forbids you to change the indexing, and maybe not even how the data is stored.  Never forget that you are the data keeper of the company!

You can, except when it's the first post of the thread .