January 16, 2003 at 2:39 pm
I am using SQL Server 2000. According to the sp_dboptions stored procedure, the following options are OFF on my database: ANSI PADDING and CONCAT NULL YIELDS NULL. Yet, when querying the database via query analyzer I get fields that are padded and I get NULL values when concatinating. I can SET the CONCAT NULL YIELDS NULL option when running the query to get the concatination results I want. However, according to the documentation the database option should do the trick. Am I doing something wrong ?
Thank you !
January 16, 2003 at 3:38 pm
This is one of those gotchas many people miss.
In QA pres CTRL+SHIFT+O or select Tools/Options on the menu bar.
Now on the new dialog select the "Connections Properties" tab. When you get there it will all make sense.
The problem is the connection settings always override the DB defaults and QA has both of these and some others set ON.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply