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 |
|
Krb_iiaba
Starting Member
16 Posts |
 Posted - 2005-01-13 : 15:17:04
|
| I have a db that I am trying to setup replication for. A table in this particular db has a field with an image data type (trust me, I didn't design the schema for this db [i would store images outside of my db]). The developer who did design the db schema changed the default length for the image type from 16 to 32 (so that he could store larger files... go figure) When I configure the subscription for replication, it continuously errors out because the lengths on the image data type don't match (32 on live server, and 16 on the replication subscription server). I have run the sp to change the length from 16 to 32 on the subscription server but it keeps changing back after a couple of minutes. Am I going crazy or just missing something? Perhaps run_values vs. config_values? Any thoughts or ideas would be greatly appreciated.Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-01-13 : 15:57:55
|
| You say that you are seting the length of the image data. Do you mean that you are using the "SET TEXTSIZE" command? If so, this is a session level setting.HTH=================================================================Scriptures, n. The sacred books of our holy religion, as distinguished from the false and profane writings on which all other faiths are based.-Ambrose Bierce, writer (1842-1914) [The Devil's Dictionary] |
 |
|
|
Krb_iiaba
Starting Member
16 Posts |
Posted - 2005-01-13 : 16:28:12
|
| Actually, using sp_tableoption to change the length from 16 to 32 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-13 : 20:53:40
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44695 |
|
|
|
|
|
|
Image Data Type