dbursey (5/30/2012)

---

Hello - I'm wondering if anyone has some elegant way to handle this problem: I have participant/event data. I gather all the participants to any of a selected...

So, we had this issue at my previous company. Now, this database was refreshed nightly and not updated during the day... So this is a bit different. However,...

This is a 2008 forum. You will have better luck getting responses if you post to the proper forum.

I have not seen this error, but logic tells me to remove the hint from the object. 🙂 Not sure if that counts as a work around or a solution.

What exactly are you referring to as "upgraded?" For example, when I restore a 2005 database to 2008, it will have a compatibility of 90 (2005) unless I change it.

No reason to use Jeff's splitter if the data format is constant:

use tempdb

go

declare @test-2 varchar(125)

SET @test-2 = 'barrington, il 60010-4020'

SELECT RIGHT(@test, 10) AS zip, SUBSTRING(@test, CHARINDEX(',',@test)+2, 2) AS state, SUBSTRING(@test,...

Look... I just want to say, and I am no expert, but it seems clear from all of my research and time spent on this forum that to improve performance...

For those interested... It seems that they did not "deprecate" the feature of Transactional Replication with Updatable Subscriptions, but removed the option from the Wizard. You can still create...

timwell (5/24/2012)

---

Lynn Pettis (5/24/2012)

---

Perhaps Service Broker could be used. I would have to do some investigating to be sure, but it sounds like another viable alternative.

---

Instead of a web application,...

Sean Lange (5/24/2012)

---

SQLKnowItAll (5/23/2012)

---

Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things to...

Jeff Moden (5/23/2012)

---

SQLKnowItAll (5/23/2012)

---

Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things to...

SQL Kiwi (5/23/2012)

---

I just downloaded Schema Surf to try it on AdventureWorks. I have to say it's very impressive, and much more...

SQL Kiwi (5/23/2012)

---

Or, more to the point, that they can...

Personally, I have never used any tools. I look at it like a big puzzle. Of course, I first look for table names and columns that are named the...

GilaMonster (5/23/2012)

---

SQLKnowItAll (5/23/2012)

---

Come on... That's like saying a column...