s1123 (3/27/2012)

---

hi..

i like to know if i upgrade sql sever 2000 db to 2008 db and after 10 days if developers had problem with compatibility or other and my client...

obarahmeh 5846 (3/27/2012)

---

And if it is the best solution, how can our applications redirect to the subcriber server if the primary server is down???

Is there any thing to use that...

I would say you need to do a bit more research into SQL's high availability options. Transactional replication "could" be used in this way but it is far from...

I purposefully avoided the language comparisions as there is nothing wrong with either as both can accomplish the same jobs.

Popularity is a different and one is clearly more popular than...

Audit purposes is probably one of the few cases I'd stick with triggers as it prevents people...

To start with, you are better off with three...

Andy Hyslop (3/23/2012)

---

It depends on many things, how many triggers, how well written, data types, how many tables they are hitting the list goes on.

I will say that yes a...

Of course there is. Depending on what action(s) they cover on the table the code potentially has to process in full or partially. They usually include reads/writes to...

You can create a database snapshot on a mirrored database to make it readonly if thats of any use.

EXEC sp_changepublication @publication = 'publication'

, @property = 'replicate_ddl'

, @value = '0'

/*...

AK1516 (3/22/2012)

---

Can some one help me out in educating what does status = 25 or 17 mean in sysarticles on publication database. What does that indicate ?

Any clue ...

The transaction log will not be cleared on a replicated database until the commands that are meant to be replicated are hardened to the distribution database. This is done...

No easy cut and paste way. You can generate a couple of scripts using dynamic sql to attach/detach. Perhaps a powershell script to wrap it up and do the...

steve smith-401573 (3/21/2012)

---

Instance or Server Name? My understanding is you CANNOT rename an instance. The article referenced talks about renaming the server. And, yes, the server name...

I would follow the steps in here to remove replication

Having used sp_removedbreplication before it appears to do so indiscriminately. Its worth a shot

http://msdn.microsoft.com/en-us/library/ms147921.aspx