Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ias0nas
Starting Member
36 Posts |
 Posted - 2011-08-03 : 15:49:11
|
| Hi,I have an interesting problem, it might have to do more with .NET but I'll ask the question anyway.I have a fairly big and complex SPROC that is taking a couple of minutes to get results back.The default language of the server is us_english.I was using a connection string that was specifying language=British in my application.It turns out that if I don't specify the language in the connection string the results from that SPROC (in the application) come back in seconds. There is not difference when executing the SPROC from within SQL Manager, the results always come back in seconds.So, I thought of removing the language from the connection string and changing the default language of the user the application uses. Same problem, if I change the default language of the application user to British it takes a couple of minutes for the results to came back.Any ideas?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Different server and login default languages