April 8, 2003 at 1:51 pm
SQL 7.0 creates tables by default using ANSI PADDING ON.The only solution to get around this is to type SET ANSI PADDING OFF before any DDL query (create or alter)If, by mistake, I forgot that line, the table will be ansi-padded forever and I cannot make it back non-padded.What to do?
Mohamad Ad-Deeb
Senior Software Developer, Microtech
3 Mossadak st. Dokki 12311
Giza, Egypt.
Tel. +20 2 336 9855 (Ext.112)
Fax +20 2 749 8784
http://www.microtech-eg.com
April 9, 2003 at 4:32 am
This is set on a per-connection basis. The way to control from the server, open EM and right click the Server in question, choose properties and goto the Connections tab. In the section "Default connection options" you will find where you can set on or off per connection. However it is off by default in 7 not on.
So if on for you are you using QA when this happens? If so the problem is QA has some settings turned on in options by default. Open Tools->Options then goto the "Connection Properties" tab, you will see the option in the bootm half of that tabs dialog area.
If using another app then that app must be setting the option at connection itself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply