It doesn't depend on the SQL Server setting but on the setting of the date format setting at the point the INSERT statement.

It is influenced by the following settings:

SET DATEFORMAT

SET LANGUAGE

The language setting of the user running the command / batch / sproc

The server setting

If you want to avoid dealing with different settings for date format, I'd recommend to use the ISO standard: YYYMMDD HH:MM:SS.

So, instead of sending "10/01/2000" you should either use "20000110" or "20001001", depending on the date it refers to.

This will always convert to the same date, regardless of the settings mentioned above.