I guess you'd better do that on the AS/400 side: wrap the program call into a stored procedure and then call it from SQL Server.

I've always done it this way...

Nice article, Wayne!

And I also liked your post on the performance comparison on your blog.

Cool stuff. Thank you.

patelmohamad (8/30/2011)

---

Hi Sean,

Agree with you but in Asp.Net application we holds the data in DataTable,List or Dataset Basically the Data holder and then display in grid, my question is same...

Glad to hear you solved your problem!

You could have seen it clearly from the execution plans, by the way.

This is why it's so important to always include actual execution...

Jeff Moden (8/29/2011)

---

I wish I could say "Yes" to try to help the person feeling infringed upon but, No I don't....

You can set it up from the alert configuration applet, in the "Response" tab.

You can either run a job or email an operator (or both things).

Nice article!

I've been using this trick for years and I must say it works quite well. The only thing I don't like about it is the need to add custom...

Another method:

WITH Test(TestField) AS (

SELECT 'aaa'

UNION

SELECT...

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...

Ignacio A. Salom Rangel (8/26/2011)

---

Gianluca Sartori (8/26/2011)

---

Maybe an explicit deny?

SELECT DB_NAME() AS database_name,

PR.name AS principal_name,

PE.permission_name,

...

Maybe an explicit deny?

SELECT DB_NAME() AS database_name,

PR.name AS principal_name,

PE.permission_name,

OBJECT_NAME(PE.major_id) AS object_name

FROM sys.database_principals...

This article[/url] by Jeff Moden should put you in the right direction.

Hope this helps

Gianluca

I mean under database users.

Do you have a database user for any of those logins in the group?

SanDroid (8/25/2011)

---

Steve Jones - SSC Editor (8/25/2011)

---

It's not a big deal, and he has a bit of a point. None of the answers is well written, as noted by Hugo.

Leave...

However, you should see a database user for each single user in the windows group. Have you tried deleting them?