Not sure why you would need to be testing a date if the staging table already contains the rows that you need? And I certainly do not know why...

The involvement of ServiceBroker seems particularly odd to me. Are you perhaps using Database Mirroring?

A bit tongue in cheek perhaps, but my point is serious: database administration should not be doing something like this own their own and independent of the Applications or the...

Marcia Q (3/26/2010)

---

Management wants a report of columns that are personal data, so that we can make sure we are protecting that data from misuse. I need to find...

There are several thousand scripts here at SQL Server Central, could you please indicate exactly which one you mean?

Nice idea Paul. I've tried some things like this in the past, but I could never seem come up with a query pattern that would be retain a stable...

Ah, nice idea. I like that one.

Didn't I just answer this question ... ?

Paul White NZ (3/26/2010)

---

RBarryYoung (3/26/2010)

---

I think that my previous two replies on that thread pretty much explained anything that Moriarty ever has (or likely ever will) say*.

*(??? Hmmm,...

Jeffrey Williams-493691 (3/26/2010)

---

RBarryYoung (3/26/2010)

---

Trey Staker (3/26/2010)

---

Kit G (3/26/2010)

---

[... I also didn't realy understand what she was trying to get across and she didn't take the time to clarify her prior...

The SQL Server "Duration Time" probably is not including some or all of what is normally called the "transmission time", that is, the network+etc time that it takes to transmit...

Have you tried a query like this?:

SELECT MAX(CAST(LTRIM(CAST(subID AS VARCHAR(MAX))) AS bigint)) AS id

FROM

(

SELECT

...

As long as you haven't given any of these groups special roles (sysadmin, db_owner, datareader, etc...), it shouldn't be that hard. Just like you said, first revoke ALL access...

I agree with Grant, this has the feel of a logic bug. You can post the procedure's code if you would like us to check it.

Here's a View that I wrote awhile back that should do most of what you need: http://www.sqlservercentral.com/scripts/tables/62545/