This has been discussed on other threads but to review:
Fox Sports New Orleans is, for right now, ONLY for Hornets games and other Hornets broadcasts, such as the coaches show and whatever else they decide to do.
Other than that, we will get the same FSN Southwest feed that we always have gotten.
So, it will go live for whatever the first broadcast is. I would guess that they might do a small preview show, but it is more likely that it will go live on opening night.
As far as who will get it, anyone whose cable/satellite includes FSN Southwest who is deemed by the NBA to be in the Hornets TV Market will get it. Now, who exactly that is, i have no idea. I would guess that all of Louisiana will be included. Now, I also have no idea about the Mississippi Coast, as I do believe that they do not get FSN Southwest (FSN South maybe...Mississippi people help me out here), so I do not know if Fox Spots New Orleans will be on all FSN feeds in the NBA designated Hornets TV market, or only the portion of the market who is on the FSN Southwest feed.