The where looks at the two columns that make up the PK... You code is more compact though.

But I am looking for a better way to not run the trigger...

I can disable the trigger... then once the job is finished enable.. but that means that any user activity during that time will not get the user/DT that is critical...

The trigger was created so that when the app updates the table, it also updates the user name and Date/Time. The bad news is that the app will not do...

THe Broadcom Advanced Control Suite does not seem to have a log.

It does have some running counts... by frame...

660571618 sent ok

178420228 Rec ok

5 ...

Opps.. sorry.

SQLSACT (7/15/2013)

---

dwilliscp (7/15/2013)

---

Good Article, but how do we tell what query is creating the spill over? I have been trying to figure out why a section of my job keeps...

Good Article, but how do we tell what query is creating the spill over? I have been trying to figure out why a section of my job keeps taking over...

I just noticed what the developer did.. the long where statement had the following..

... and (mcode = mcode or mcode = '(ALL)') .. and

it should have been

...and (mcode =...

Thanks... forgot about views. I do not want a wildcard.. since I need to find all tables with that exact name in it... so I can create a SQL to...

Oh... ok thanks.. will put you code back in and try it.

opc.three (6/24/2013)

---

Yes. In SSMS 2012 go to Tools > Options > Query Results > SQL Server > Results to ... and increase...

I decided to break this into two roles, working on the basic access first and have the following issue, but not sure why the code is creating this:

The last object...

Thanks Gail, I was afraid of that.

One more question... (SET TRANSACTION ISOLATION LEVEL SERIALIZABLE)

In my case what does it mean by session, when the stored proc ends or when all...

Gail sorry found the section at the bottom, and changed my last post... but you had already read what I posted before. Opps.. hit should have been hint. I cleaned...

Thanks for clearing that up Gail... That leave the following questions...

1) the example shows a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

. What does it mean by session, when the stored proc...