I was wondering why you were using NOLOCKS at all, I tend to urge caution with it and that many people don't really understand the ramifications of using it. ...

I was wondering about NOLOCKS as well...

CEWII

you could try SELECT instead of SET, but I'm curious what error you are getting?

CEWII

I'd take that challenge too. Even a simple truncate and load could be generated in a couple minutes without rushing in SSIS, I don't think that you could do...

For most cases that I have used that method The date is most important, not so much the By. I have used this in delta processes where I only...

I'm wondering why your initial load of data is flowing throw SCD, if you have all the data for current and past records it would seem like you could populate...

32 or 64-bit?

Also, it isn't real often I google an error code and get NOTHING..

Does this run at all in BIDS? I didn't see where you stated one way...

GilaMonster (1/27/2011)

---

Elliott Whitlow (1/27/2011)

---

I am torn on whether it is the apps job to fill in these fields in the first place. I'd end up with triggers to make...

64 or 32-bit? The "access denied" may not be the true problem and is screening the real one.

CEWII

I think GilaMonster made this point, for substantially the same work you should have a single trigger, for essentially different processes different triggers make sense. Also, for the insert,...

Although I generally agree that avoiding the SCD is a best practice, I was curious, you are adding 2M rows a YEAR, thats only about about 8K records a work...

My first thought is how long does the same report run if you are local on the network. From a previous experience we had a problem where the reports...

I've used SQLCLR..

Why don't you tell us a little but about what you want to do..

CEWII

Good thought Eddie.. I was also thinking a trace during the time might be ok, especially if it is just focused on permissions changes. I would think that...

Along with what Wayne said vendors that use extended stored procedures can have problems, most do not do that. For applications that operate fully within a single database and...