No, I had no luck on this but I don't recall how I handled this. Please let me know if you could get answer to this. I am curious about...

OK. Thanks again

Thanks. This query also returns "dbo", not the NT login or the database userid of the user

Thanks for your answer. I got almost the same answer from Lowell that it is not possible

The o.name displays the object name.

But even if I choose u.name, it displays the generic owner name like "dbo" or "sys", it does not display the actual owner name like...

OK. Thanks for your explanation. I am in the process of deleting unwanted tables that were created by me so I was trying to find a way to get only...

Thanks again Lowell for your suggestions.

I am not sure if this solution works because the variable @Sourcecolumn that I mentioned in my earlier code is the column name of the...

Thanks for your reply and your solution. I don't know if it works because I have to pass a parameter to the procedure. Let me try that option.

My stored procedure...

I was able to connect thru my manager's system. He has full access to remotely login into the physical server. Now, he is not available and I need to connect...

Thanks for your replies. Unfortunately, I can't connect to the server physically in order to do the windows admin settings. I only have FULL access to sql server

Yes, I am getting the following error

Connect to SSIS Service on machine "server1" failed:

Access is denied.

Connect to SSIS Service on machine "server1" failed:

Access is denied.