WAIT A MINUTE! ARE YOU SURE YOU WANT TO DROP YOUR INDEX?

Not entirely sure what's going on, but it looks like your going to drop (have dropped) the primary key...

Sounds to me like this may be a "double hop" issue, where authentication is not working.

In short, if you're going from A to B to C (Delphi to SQLSvr1 to...

Hi,

If you select from the synonym does that work?

I assume he's talking about a variation on the following, which is what SQL Server will create for you, if you create your fks from a diagram for example (which...

Below is my CTE effort, which won't work on SQL2000, but which does consider multiple fkeys.

I'm not entirely sure what the 'standard' convention is, as it seems to depend on...

Chris,

A foreign key isn't necessarily between 1 field in each table. If you have a composite primary key made up of 4 fields, for example, then a foreign key...

Thanks for the script. 🙂

It's a good idea, but potentially you could get duplicates, where you have multiple foreign keys between the same 2 tables.

But those could easily be...

Michael Valentine Jones (2/9/2010)

---

I think you are ignoring the cost of what happens when you insert the data.

I think it would cause intense fragmentation of the index if you inserted...

Thanks Jeff,

Yeah, I know that the sort order isn't guaranteed, even if the index is clustered. It's just pretty much always the case, and so can be handy. ...

Sorry to come in so late....this might have been useful a few posts ago.

...but I see yours is pretty much the same, Jeff.

Linking to the previous row[/url]

I wouldn't have thought it would perform any sort operation i.e. it wouldn't re-sort your index just because it was ascending instead of descending. I assumed it would just...

I understand your point, but I would suggest that you could say the same about the data in the target audit tables. i.e. a privileged user would be able to...

Hi Lynn,

Thanks for that - it worked! (But I don't remember this being a requirement for a deterministic function!?)

I was then faced with the problem that my function was...

Ramon-218872 (10/29/2009)

---

Hi to all,

I'm trying to use the code, because it's that I need, but I get the error:

Msg 7357, Level 16, State 2, Procedure sp_ConvProc2View, Line 27

Cannot process the...

Tom Garth (10/29/2009)

---

David McKinney (10/29/2009)

---

ruedifuchs (10/29/2009)

---

I agree, the code for using OPENROWSET is very interesting.

But since the stored procedure has to return a result set, what is the advantage over...