|
 |
Now you can stay up on all the Space Coast SQL Users Group happenings... on your Windows Phone.
Chek out a demo of the mobile app here.
Download it for FREE here.
|
 |
|
|
|
|
|
|
Space Coast
SQL Users Group
"A collaboration of Database Administrators, Developers and IT Professionals passionate about advancing and sharing their expertise in SQL"
  
|
|
|
|
|
|
|
Sep
21
Written by:
Seth Phelabaum
9/21/2011 10:55 PM
Because this was a problem that Google was zero help on and I did find a couple other people afflicted with it, I figured I’d write a post about it. The issue was this. I add a table to replication (SQL Server 2005). The option to replicate DDL changes is set to true, vertical_partition on the article is set to false. From everything you’ll read about replication (in 2005+, 2000 didn’t work this way, you needed to use the column add/delete procs), it should now just work. Sure, you’ll find some posts floating around out there about people with random problems that resembled this and the fixes usually just involve turning on the option to replicate schema changes or some other such basic fix. Not the case here. I tried everything I could think of. Rebuilt the publications from scratch. Dropped replication all together on the server and added it back (to be fair this might have temporarily worked, but I don’t feel like dropping it and re-creating it all again to verify). The issue turned out to be… the replication DDL triggers (in this case, specifically sp_MSTran_altertable). These are database level triggers (introduced in 2005, which is why 2000 doesn’t work the same way) that fire when you do things like alter the schema of a table or push a stored procedure change. They had managed to become disabled (most likely by the careless hacking together of a partial script generated by SQL Compare, my fault, not the tool’s fault, this was a dev environment). The publication level option to replicate schema changes is what tells replication you want them propagated to your subscribers, but the triggers are what enable this to happen. One of the things that really threw me off here is that when I scripted out the publication after I had initially created it (and before I had tried to add any columns), I saw a correct replication script, with the vertical_partition option set to ‘false’. Add a column and re-script out the publication and you see that the vertical_partition option changes to ‘true’ and you get all the columns that were part of the original definition of the table added to the script via sp_articlecolumn. This led me to believe that somehow something in replication was switching this on me behind the scenes… but really I believe this was just a side effect of the script process trying to generate scripts based on the current state of the publication (and I don’t know that the vertical_partition option is actually stored anywhere). So, one more thing to check if this happens to you, and hopefully it saves you the many hours of replication rebuilds and fruitless Googling it took to figure this out. (And to be fair, it was actually a co-worker who thought to check the triggers, I probably would have been several more hours at it!) And now a few more search terms to hopefully help Google find this: SQL 2005 Replication not replicating Schema properly. schema replication stopped working vertical_partition option getting changed to true
Tags:
16 comment(s) so far...
Re: SSMS Tools Pack – Script Grid Results
The Paris-based LVMH Moet Hennessy Cheap Michael Kors bags S.A., the world's largest luxury goods company, said yesterday that it had bought 33 percent of the American fashion house Michael Kors outlet L.L.C., but did not disclose the terms of the transaction. The remaining ownership will be shared in equal parts with the designer Michael Kors handbags outlet, co-president and artistic director of the fashion house, and the co-president and managing director, John Orchulli. LVMH has shown interest in acquiring Armani and Gucci Group.Yesterday, Michael Kors Skorpios woke up. Obviously, he has been waking up every day of his life and smelling the coffee and doing whatever else a Michael Kors Shouder Bags does to remind himself that he is still alive. How does designer Michael Kors Messenger Bags see spring? Well, it's either ladylike and demure or sexy and '80s.
By bestlucklyzgt on
6/17/2012 10:26 PM
|
|
|
|
|
|
|
Re: Replication DDL Triggers
ugg australia 25, www.officialtexansnflshop.com Ultrashort Emerging Russell Wilson Jersey Markets www.cheapbootssaleinuk.co.uk in Arian Foster Jersey fund; www.officialtexans.com long Ultrashort ugg boots Emerging Markets J.J. Watt Red Jersey in J.J. Watt Game Jersey
By freugg on
10/19/2012 2:17 AM
|
|
|
|
|
Re: Replication DDL Triggers
Here gives you some information on [url=http://www.gpseller.com/runescape-gold.html]runescape gold[/url] service.The website is gpseller.com.
You can get best service around the clock in gpseller to [url=http://www.gpseller.com/runescape-gold.html]buy runescape gold[/url].Here gives you some information on runescape gold service.
Here runescape gold allows paid online.You can pay for [url=http://www.gpseller.com/runescape-gold.html]cheap runescape gold[/url] online now.
By gpseller on
12/10/2012 4:28 AM
|
Re: Replication DDL Triggers
Here gives you some information on runescape gold service.The website is gpseller.com.
You can get best service around the clock in gpseller to buy runescape gold.Here gives you some information on runescape gold service.
Here runescape gold allows paid online.You can pay for cheap runescape gold online now.
By gpseller on
12/10/2012 4:30 AM
|
Re: Replication DDL Triggers
Of course,runescape gold is mainly because it is not possible - in addition to the pleasant competitive, and free historical realism, you can use a lot of people is quite easy.
It is my opinion, seems to rs gold game which can buy Cheap RS Gold and almost all of the customers usually in young people.
In addition hear the men and women of the many online cheap runescape gold games involved in such an atmosphere of about 20.The website is gpseller.com.
runescape items
buy runescape gold
By gpseller on
12/11/2012 3:35 AM
|
Re: Replication DDL Triggers
You can buy runescape gold here in gpseller and you can have many many choices to select your right runescape gold here.The quantity of guys and girls that populate is a good offer much additional in comparison to country of Liechtenstein!Runescape need to certainly be the complete quantity just one rated inside the net on the net film game in simple fact played.Runescape gold features a good offer much additional than 197,000 guys and girls and there is no signal of abating.The on the game also holds the report producing utilization of the quantity of rs gold gamers and
gold4fun in www.gold4fun.com inside the net simultaneously engaged within extremely exact activity.Also identified like a MMORPG (massively multiplayer inside the net role-playing game). The website is gpseller.com.
By gpseller on
12/13/2012 4:43 AM
|
Re: Replication DDL Triggers
Buy Large Quantities Of Cheap Rs Gold In RS2CHEAP
Here are runescape golds . Just check them into your account .Under the Kalpavruksha plan , if you opt for an 18 month deposit, you are eligible for an additional cash benefit that is equivalent to two months' instalment.For longer duration schemes, some customers who buy cheap runescape gold offer a higher cash bonus.The website is rs2cheap.com .
When you buy large quantities of cheap rs gold ,you will be able to buy runescape gold by investing only Rs 55,000.The twelfth instalment, which is equal to your monthly contribution, is paid by the retailer. So, if you invest Rs 5,000 a month in the scheme, after 11 months you would have invested Rs 55,000 and Tanishq will put in an additional Rs 5,000 as the last instalment.The website is rs2cheap.com .
There are many different meanings to best rs gold .But you can get it from rs2cheap.And there are many different meanings to best rs gold .But you can get it from rs2cheap. For instance, multi-brand jewellery store Gitanjali Jewels offers a scheme 'Swarna Mangal Kalash', wherein you can book rs gold every month in multiples of 1 g at the existing cheap rs gold for 18 months. There is another form of savings scheme, which lets you book small quantities of cheap rs gold every month at the prevailing rates, instead of converting the savings into buy runescape items at the final price.The website is rs2cheap.com .
By gpseller on
12/21/2012 5:11 AM
|
aspirateur pas cher
nice homepage
# aspirateur pas cher
By TrackBack on
3/26/2013 11:45 PM
|
woodworking
please refer to this site
# woodworking
By TrackBack on
3/27/2013 10:42 PM
|
tao of badass
please refer to this site
# tao of badass
By TrackBack on
4/3/2013 10:34 PM
|
polo pas cher
High-TechLe groupe sud-coréen a dévoilé dimanche un nouvel appareil, ?par les forces de lordre avant le clasico prévu à 21 heures? ?SUD sappuie par ailleurs sur un arrêt de la cour dappel de Paris concernant la filiale Faurecia de PSA, ? A maillot arsenal 2013 exterieur AUSSI Le site dOlivier Voisin! Tsonga sort alors deux aces au bon moment et remporte le set 7-6 huit points à six! a annoncé polo pas cher officielle dinformation AIN? quelques heurts ont short inter milan lieu en Cisjordanie. ?Celle-ci sera présentée au Mobile World Congress de Barcelone Espagne qui souvre lundi.
# polo pas cher
By TrackBack on
5/15/2013 10:52 AM
|
|
|
|
|
|
|
|
You must be logged in and have permission to create or edit a blog.
|
|
|
|
|
|
|
Sep
21
Written by:
Seth Phelabaum
9/21/2011 10:55 PM
Because this was a problem that Google was zero help on and I did find a couple other people afflicted with it, I figured I’d write a post about it. The issue was this. I add a table to replication (SQL Server 2005). The option to replicate DDL changes is set to true, vertical_partition on the article is set to false. From everything you’ll read about replication (in 2005+, 2000 didn’t work this way, you needed to use the column add/delete procs), it should now just work. Sure, you’ll find some posts floating around out there about people with random problems that resembled this and the fixes usually just involve turning on the option to replicate schema changes or some other such basic fix. Not the case here. I tried everything I could think of. Rebuilt the publications from scratch. Dropped replication all together on the server and added it back (to be fair this might have temporarily worked, but I don’t feel like dropping it and re-creating it all again to verify). The issue turned out to be… the replication DDL triggers (in this case, specifically sp_MSTran_altertable). These are database level triggers (introduced in 2005, which is why 2000 doesn’t work the same way) that fire when you do things like alter the schema of a table or push a stored procedure change. They had managed to become disabled (most likely by the careless hacking together of a partial script generated by SQL Compare, my fault, not the tool’s fault, this was a dev environment). The publication level option to replicate schema changes is what tells replication you want them propagated to your subscribers, but the triggers are what enable this to happen. One of the things that really threw me off here is that when I scripted out the publication after I had initially created it (and before I had tried to add any columns), I saw a correct replication script, with the vertical_partition option set to ‘false’. Add a column and re-script out the publication and you see that the vertical_partition option changes to ‘true’ and you get all the columns that were part of the original definition of the table added to the script via sp_articlecolumn. This led me to believe that somehow something in replication was switching this on me behind the scenes… but really I believe this was just a side effect of the script process trying to generate scripts based on the current state of the publication (and I don’t know that the vertical_partition option is actually stored anywhere). So, one more thing to check if this happens to you, and hopefully it saves you the many hours of replication rebuilds and fruitless Googling it took to figure this out. (And to be fair, it was actually a co-worker who thought to check the triggers, I probably would have been several more hours at it!) And now a few more search terms to hopefully help Google find this: SQL 2005 Replication not replicating Schema properly. schema replication stopped working vertical_partition option getting changed to true
Tags:
16 comment(s) so far...
Re: SSMS Tools Pack – Script Grid Results
The Paris-based LVMH Moet Hennessy Cheap Michael Kors bags S.A., the world's largest luxury goods company, said yesterday that it had bought 33 percent of the American fashion house Michael Kors outlet L.L.C., but did not disclose the terms of the transaction. The remaining ownership will be shared in equal parts with the designer Michael Kors handbags outlet, co-president and artistic director of the fashion house, and the co-president and managing director, John Orchulli. LVMH has shown interest in acquiring Armani and Gucci Group.Yesterday, Michael Kors Skorpios woke up. Obviously, he has been waking up every day of his life and smelling the coffee and doing whatever else a Michael Kors Shouder Bags does to remind himself that he is still alive. How does designer Michael Kors Messenger Bags see spring? Well, it's either ladylike and demure or sexy and '80s.
By bestlucklyzgt on
6/17/2012 10:26 PM
|
|
|
|
|
|
|
Re: Replication DDL Triggers
ugg australia 25, www.officialtexansnflshop.com Ultrashort Emerging Russell Wilson Jersey Markets www.cheapbootssaleinuk.co.uk in Arian Foster Jersey fund; www.officialtexans.com long Ultrashort ugg boots Emerging Markets J.J. Watt Red Jersey in J.J. Watt Game Jersey
By freugg on
10/19/2012 2:17 AM
|
|
|
|
|
Re: Replication DDL Triggers
Here gives you some information on [url=http://www.gpseller.com/runescape-gold.html]runescape gold[/url] service.The website is gpseller.com.
You can get best service around the clock in gpseller to [url=http://www.gpseller.com/runescape-gold.html]buy runescape gold[/url].Here gives you some information on runescape gold service.
Here runescape gold allows paid online.You can pay for [url=http://www.gpseller.com/runescape-gold.html]cheap runescape gold[/url] online now.
By gpseller on
12/10/2012 4:28 AM
|
Re: Replication DDL Triggers
Here gives you some information on runescape gold service.The website is gpseller.com.
You can get best service around the clock in gpseller to buy runescape gold.Here gives you some information on runescape gold service.
Here runescape gold allows paid online.You can pay for cheap runescape gold online now.
By gpseller on
12/10/2012 4:30 AM
|
Re: Replication DDL Triggers
Of course,runescape gold is mainly because it is not possible - in addition to the pleasant competitive, and free historical realism, you can use a lot of people is quite easy.
It is my opinion, seems to rs gold game which can buy Cheap RS Gold and almost all of the customers usually in young people.
In addition hear the men and women of the many online cheap runescape gold games involved in such an atmosphere of about 20.The website is gpseller.com.
runescape items
buy runescape gold
By gpseller on
12/11/2012 3:35 AM
|
Re: Replication DDL Triggers
You can buy runescape gold here in gpseller and you can have many many choices to select your right runescape gold here.The quantity of guys and girls that populate is a good offer much additional in comparison to country of Liechtenstein!Runescape need to certainly be the complete quantity just one rated inside the net on the net film game in simple fact played.Runescape gold features a good offer much additional than 197,000 guys and girls and there is no signal of abating.The on the game also holds the report producing utilization of the quantity of rs gold gamers and
gold4fun in www.gold4fun.com inside the net simultaneously engaged within extremely exact activity.Also identified like a MMORPG (massively multiplayer inside the net role-playing game). The website is gpseller.com.
By gpseller on
12/13/2012 4:43 AM
|
Re: Replication DDL Triggers
Buy Large Quantities Of Cheap Rs Gold In RS2CHEAP
Here are runescape golds . Just check them into your account .Under the Kalpavruksha plan , if you opt for an 18 month deposit, you are eligible for an additional cash benefit that is equivalent to two months' instalment.For longer duration schemes, some customers who buy cheap runescape gold offer a higher cash bonus.The website is rs2cheap.com .
When you buy large quantities of cheap rs gold ,you will be able to buy runescape gold by investing only Rs 55,000.The twelfth instalment, which is equal to your monthly contribution, is paid by the retailer. So, if you invest Rs 5,000 a month in the scheme, after 11 months you would have invested Rs 55,000 and Tanishq will put in an additional Rs 5,000 as the last instalment.The website is rs2cheap.com .
There are many different meanings to best rs gold .But you can get it from rs2cheap.And there are many different meanings to best rs gold .But you can get it from rs2cheap. For instance, multi-brand jewellery store Gitanjali Jewels offers a scheme 'Swarna Mangal Kalash', wherein you can book rs gold every month in multiples of 1 g at the existing cheap rs gold for 18 months. There is another form of savings scheme, which lets you book small quantities of cheap rs gold every month at the prevailing rates, instead of converting the savings into buy runescape items at the final price.The website is rs2cheap.com .
By gpseller on
12/21/2012 5:11 AM
|
aspirateur pas cher
nice homepage
# aspirateur pas cher
By TrackBack on
3/26/2013 11:45 PM
|
woodworking
please refer to this site
# woodworking
By TrackBack on
3/27/2013 10:42 PM
|
tao of badass
please refer to this site
# tao of badass
By TrackBack on
4/3/2013 10:34 PM
|
polo pas cher
High-TechLe groupe sud-coréen a dévoilé dimanche un nouvel appareil, ?par les forces de lordre avant le clasico prévu à 21 heures? ?SUD sappuie par ailleurs sur un arrêt de la cour dappel de Paris concernant la filiale Faurecia de PSA, ? A maillot arsenal 2013 exterieur AUSSI Le site dOlivier Voisin! Tsonga sort alors deux aces au bon moment et remporte le set 7-6 huit points à six! a annoncé polo pas cher officielle dinformation AIN? quelques heurts ont short inter milan lieu en Cisjordanie. ?Celle-ci sera présentée au Mobile World Congress de Barcelone Espagne qui souvre lundi.
# polo pas cher
By TrackBack on
5/15/2013 10:52 AM
|
|
|
|
|
|
|