I suppose I don't understand the point. We know that when records do not exist in the RIGHT table that NULLs are returned. So why would we expect...

Did you guys (and gals) notice the original question and poorly written table structure? I think this is a state reference table with 50 entries. I'd just manually redo it......

When you change the accounts, are you making sure to do it through Configuration Manager?

So, now that you have effectively shrunk a log that will inevitably grow again...

erics44 (8/30/2012)

---

Hi

can you deploy the same report to multiple locations with different default params?

I have one report I would like to default to a number of places on the report...

For those reading this and wondering why... It is because when you pull the data through OPENQUERY and do the count "locally," you have to move all of the data...

Are all columns being replicated?

If it is set to Manual, I wouldn't worry about anything else with that. Let me go back and read your first post again and see if I missed...

So, it is possible that you exceeded the range... I would change it to manual if you want to let...

ryan_xh (8/29/2012)

---

Hi all,

I have created a pull transactional replication where the replication was running fine until the following error occured for a particular table:

"Replication-Replication Distribution Subsystem:..Column name or number of...

I have just verified that...

Yes.

ben.brugman (8/28/2012)

---

I stumbled onto the following books:

Microsoft SQL Server 2008 Internals (Kalen Delaney)

SQL-SERVER MVP Deep Dives

SQL-SERVER MVP Deep Dives Volume 2

These look good value to me and a good set.

(I...

John Waclawski (8/27/2012)

---

Ironically I had that very same page opened when I wrote the email. But it didn't say how to implement...

Google "HTML add color to a table"

http://www.htmlgoodies.com/tutorials/colors/article.php/3478971/So-You-Want-Color-in-a-Table-Huh.htm