Executing a procedure is allowed on a one-by-one basis of the procedure.

You can give explicit CREATE PROCEDURE permissions in 2k8, but they need ALTER permissions on the schema they're going...

GSquared (11/28/2011)

---

Yep! I can just...

Just had to give us time...

Roy, an excellent walkthrough on the mechanics of something I've basically avoided. You highlighted its difficulties and its uses quite well.

Thanks for the article.

Hope you all had a happy holiday! I'm baaack. And sorry, just need a moment of vent:

[RANT!]

Stupid lousy antique piece of crap system doing double/triple back to back...

npcrwill8 (11/25/2011)

---

In summary, when I do a simple query in SS_2000 query analyzer against a sql 2000 databases that runs on a local server, I can see 201 ms as...

Dominic Gagné (11/24/2011)

---

Actually, it look like it was a security issue.

I created a new local account with administrative rights and configured the SQL Agent service to log on with this...

WolforthJ (11/23/2011)

---

When the team does the equivalent of locking the door to the cubes and finds that a meeting with the business people the equivalent of an hour of water...

peter.row (11/23/2011)

---

However what you said is totally one sided. You seem to be saying that the business people can get away without explaining to you or helping you understand what...

JP Dakota (11/23/2011)

---

Just happened yesterday, if you're wondering. A DBA added a column in the middle of the existing columns in a critical table. No kidding.

Other than that I'm...

Dominic Gagné (11/22/2011)

---

thanks for the replies

When I execute the package from the SSIS server (by doing a Run Package) it works fine. Does running a package this way also involve...

gmcnitt (11/23/2011)

---

Craig,

This is woking really well! I am going to present a report to the facility today based on last nights activities, and hopefully get these guys in line....

Getting a varchar() to int conversion failure is kind of strange here. Any chance you can post the DDL to the two tables?

Thank you for bringing this topic to light, if briefly.

You're absolutely right, and it's why I prefer to bring on employees who were contractors in one point in their life....

I love how well Google Translate does grammar...

Why contradict a woman? There is so much easier to...