K. Brian Kelley (12/11/2008)

---

I'll look at writing that up. I...

I'm not going to address all th code in this post, but will quickly say that you should rethink the trigger because it will only work for a single row...

I recommend that you read this article[/url] before proceeding any further.

Lynn Pettis (12/11/2008)

---

I chose to obey all traffic laws. I'm the one every gets ticked at because I drive the speed limits, stop (yes, actually stop) at stop signs,...

No one can accurately answer this question without seeing the code you are using.

If you check out this thread you'll see that method you are using is the consensus pick for best performing.

Of course as Gail asked, why do you want to avoid...

It would would help if you would post some sample data. I would suggest that you attach sample files to the thread and then include the DDL for the...

No one can accurately answer this question without seeing the code you are using. If you post some code we can help.

With the limited information you are giving I...

Michael Earl (12/11/2008)

---

I was thinking the same thing just after I posted. I figured I would leave later.

Also, we currently have no evidence that Lynn has ever run anyone...

In SSMS and the object explorer right-click on the database select Tasks -> generate scripts and this will walk you through generating the scripts for your database.

I'm not sure what else I can explain for having drill-down, which I assume you meant hide...

But is it safe to be walking if Lynn is driving alone? I might just choose to stay home.:P

I also made the assumption, along with the others in the 70+% who answered yes at this point, that a full backup was available.

I also understand, although I don't totally...

Great article Brian. Will there be a follow-up on setting up Kerberos delegation? I could use it.

Check your lookups. It sounds like you have duplicate values in one of the lookups. Like this:

Col1

-----

1

2

3

4

Lookup Table

LookupCol NewValCol

---------- ----------

1 ...