john-902052 (8/20/2011)

---

Hey all,

I have a question if you wouldn't mind.

I have a db Cases with an Identity column CaseID and I have a few other dbs that store the CaseID....

As it was mention that "It is pointless posting the query here - the view has 42 joins and many of those are other views (I know - don't ask...

Here are come SSC articles that can help out.

http://www.sqlservercentral.com/search/?q=move+index+filegroup&t=a&t=s

Welcome back in our SQLServer universe, Lynn.

All the best on...

Ninja's_RGR'us (8/19/2011)

---

WayneS (8/19/2011)

---

Ninja's_RGR'us (8/19/2011)

---

For those who followed. Paul and I have each posted a connect item for a nasty issue with rollback (corrupts your db). It seems to...

SqlSpider... (8/19/2011)

---

In TableA i am having composite Primary key for the columns (id,num)

In TableB i have to set a foreign key for the column 'num'

I was given like this:-

create...

WayneS (8/18/2011)

---

Steve Jones - SSC Editor (8/18/2011)

---

Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No...

Thank you for the feedback. :smooooth:

I've been looking for such kind of bug info for your thread, but apparently did google/bing the wrong key words :crazy:

It seems to be spot...

First question: What are you trying to accomplish using the id+num column combination ?

( Why not only the id column as pk and an uk on num+id ?)

A foreign key...

Jim Murphy (8/18/2011)

---

Hahahaha. Great chuckle. Thanks.

Say, I...

Steve Jones - SSC Editor (8/18/2011)

---

Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal...

Grant Fritchey (8/18/2011)

---

GilaMonster (8/18/2011)

---

Jim Murphy (8/18/2011)

---

I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting...

Work hard 🙂

I published an avoidance script a long time ago (0001/01/01):help to tighten use of cmdshell or sp_start_job[/url]

... However, the visceral fear...

If you didn't pass the test, sue the professor ! :hehe:

Jeff Moden (8/17/2011)

---

ALZDBA (8/17/2011)

---

As I said to Perry, I have a real appreciation for that. Let me ask this though. If an attacker can get into your system...