We didn't change the proxy account password. We changed the service account passwords.

What do you mean by refresh the password? Do you mean reboot the server?

Really as long as they customer gets the information, I don't think it would matter

Hi, I didnt realize that I sent the script with an xls extension. I had changed it to a csv file and it still didn't work. When I...

thank you. I was attempting to do select of individual columns and put it down. I will continue with that again and let you know

I sure hope someone can help me!

That is very good news. I found a way of doing the procedure not knowing that you can do it the way you had mentioned. I will try...

Is there a way to make this stored procedure able to provide a parameter like the database name? I want to be able to provide the database name and...

Thank you. I will try that and get back with you.

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

AND EXISTS(SELECT 1 FROM sys.database_mirroring WHERE database_id = DB_ID('archer') AND

mirroring_role IS NULL)

BEGIN

use archer

SET NOCOUNT ON

END

Msg 954, Level 14, State 1, Line...

Thank you so much for your help. I've been digging and digging so I appreciate your time.

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

AND EXISTS(SELECT 1 FROM sys.database_mirroring WHERE database_id =...

I have added what was suggested:

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

BEGIN

use archer

SET NOCOUNT ON

END

It looks good until you execute and I get this...

Oh well. I was hoping.

I've attached my error

Awesome. I will try that SQL and let you know.

Thank you Lowell. It looks like you have installed the Oracle full client not the Oracle Instant client. Is that correct?