In order for ownership chaining to work there are 3 more things that must be setup that I have not heard you mention yet:

1) the source database must be TRUSTWORTHY

2)...

balv (10/24/2008)

---

The info required is found using a key and is located on table-a or table-b. The result gave the info on table-a (if available), else found the info...

I know that in SQL Server 2000 w ODBC SQL Logins were not encrypted. I am not sure if that is still true for SQL Server 2005 and/or ADO.net...

Possibly the maintenance jobs are failing part way through?

Colin Macguire (10/24/2008)

---

The issue comes in when the user decides to connect to the Server via the ODBC connection as described above. When the user selects the connection from “MACHINE...

I really don't think that there is much that you can do here with this approach. You need to get the customer to tag them appropriately in the table.

Otherwise,...

Did you get a chance to try this?

I am not sure that there is any safe way to "Kill" the cmd.exe. I really think that you need to fix your Task.exe so that it works correctly...

As I recall, here is how you convert:

1) Place all WHERE clause comparisons in the order which their tables occur in the FROM clause. For instance, since "v" occurs...

anvieph (10/24/2008)

---

Thanks guys, I monitor the task.exe and it open new cmd.exe that never terminated. now what I need to know is how to kill the cmd.exe using vb code....

As I recall, a Lakh is 100,000.

I agree with Mahesh, this would be better (and easier!) as a stored procedure.

Glad I could help.

And definitely test this. I doubt very much that I got this right the first time.

Your terminology is not really correct here. What you are calling "Ansi" syntax, is in fact ANSI SQL-89 syntax. What you are calling SQL Server 2005 syntax is...

If the program is waiting for input from the command pipe that the SQL process used to issue the command, then a Control-C may cause it to exit. Now...