you can use "information_schema.tables" instead!

If the PKs are different you should...

Shark Energy (2/20/2009)

---

Yes but why fail? On SQL 2000 it runs as successful but with errors skipped. Skipping errors is not really dangerous when you are expecting them and on...

NO

Why would you want to do that ?

you are probably experiencing "integer" division.

Change

COUNT(Spells.Spell_Episode_ID35)/GPP.PRACTICE_POPULATION * 1000

To

1.0*COUNT(Spells.Spell_Episode_ID35)/GPP.PRACTICE_POPULATION * 1000

Shark Energy (2/20/2009)

---

Thats brilliant (both answers). Thanks!

Another side question - When you are trying to get "continue on data consistency errors" on from 2000 to 2005 - how does this...

First of all not having snapshot initialization makes you lose some "features" that help ( a lot ) when you want to incrementally maintain replication, as you are already doing.

Don't...

The only thing I can think of is to measure CPU usage (and IMHO more importantly IO overhead) with and without the agents running.

LogReader on Publisher

Distribution on Publisher if Push...

ritesh (2/19/2009)

---

Hi All, I got two scripts to remove replication

1.sp_removedbreplication

2.sp_dropsubscription

sp_droppublication

Please tell me what is the difference between them? which one is better to...

skjoldtc (2/19/2009)

---

Data without context is useless. Software helps to put data into context but humans have to study the data to make sense from it.

Danger comes from acting on data...

David Kranes (2/19/2009)

---

This will not work because select into will not give me the true definition of the table, specifically the division_id which is a computed column. I suppose...

happy to help

You probably want to use SELECT INTO, then Drop the old table and finally recreate index/PK

you probably need to roll your sleeves and do a bit of coding but here is some help:

tiff-to-pdf-converter[/url]

Example to import and export images from and to SQL 2005 Table[/url]

Hope this...