Clever Geek Handbook

SQL Profiler Connection Details

When you run a standard trace, the first settings you see will be the current connections to the database.

In my case, there are about 10 records, all of which are the same username, however, some are dateformat dmy and some are mdy. The asp site seems to pick a connection from the pool and use it, it seems to pick one of 3 and they are all set to dmy, however each connection must be mdy. Since they are all the same username and the user is set to us_english, where else could there be a connection to the dateformat record?

thank

0


source to share


1 answer


Some ideas:

  • Application issues SET DATEFORMAT
  • Application uses DSN with / without translation


By default, the default connection is determined by the default SQL Server settings.

+1


source






More articles:


All Articles