GilaMonster (9/17/2010)

---

hallhome (9/17/2010)

---

Update: I took Gail's advice and moved tempdb to another drive and recycled SQL Server. The database in question was able to recover and I was...

Now that's an interesting fix... I'll have to remember it and see if it works the next time I come across that issue.

I don't use the Designer much though, so...

sqlbuddy123 (9/17/2010)

---

Suppose that if a page is 100% full and if a new record record needs to be inserted somewhere in-between the records on that page, then SQL Server will...

Hey, all. It's been forever since I've done replication. I'm trying to help this guy out here. While I'm looking stuff up, would someone else mind sticking their nose into...

Mark,

Making assumptions with SQL Server is the quickest way of losing a database. Be careful about that.

Did you set up replication yourself or are you working with someone else's setup?...

steveb. (9/17/2010)

---

I have heard this before, that the order of the table placement in the join...

Bread Pudding with Jack Daniel sauce...

It's more than one word, but it's what I'm eating right now. Nom!

Jeff Moden (9/17/2010)

---

Of course, people are easily confused because DBA's can also be used to show possession (and no, I'm not talking about demonic possession although a lot of DBA's...

Nope.

Null = Clueless

Give us the exact wording of your error message.

Also, a row count would be nice. If you've got a wide, long table, that could take a long time no matter how well optimized your query is.

I believe, in some instances, you can make changes in the GUI that T-SQL does not enable you to make. You can try using the GUI, but don't be surprised...

It's been a while since I've played with replication, but I'll give this a shot.

How is your replication set up? Do you have Updating Subscribers? If not, chances are your...

What service pack are you running?

Wrong line. Dark Horse has that one. @=)