Thank you all for responding....

Jeff,

Everything worked perfect in the test environment...we didn't have issues in test while setting it up so moved to prod and here we are with prod.

Do...

The main problem is the provider you mentioned is not in the list of providers while creating the linked server. How to get the 'Microsoft OLE DB Provider for Oracle'...

Thank you again !

No nothing is waiting on this spid..also blocked by and blocking is 0.

Thank you again for your reply.

Now, could you help me in the linked server setup to Oracle.

The SQL...

The current wait time is 86369625 , the status says KILLED/ROLLBACK

Does this has any affect on the instance level ??

Can I leave it until the reboot schedule ?

I actually tried creating a linked server to an Oracle dataase.

The SQL is a 64 bit server so I used "Oracle OLD DB Provider " while creating the linked server...

Thank you for your reply,

I killed the process Yday afternoon around 12 PM but its still showing in the activity monitor.

Thank you for the replies.

I tried to export the package to another server and created a job to run this package but I am getting this error message :

Executed as...

Thank you very much for your help.

I finished the upgrade successfully

The commands I used to resolve this issue are :

net start $MSSQLINSTANCENAME

sqlcmd -S servername\instancename -E -A -Q"alter login <sys-admin> with...

We have one default and 4 named instance on that machine and I am trying to upgrade one of the named instance. I think I am doing something wrong at...

I tried this even...but nup same kind of errors

I tried even this but same error..incorrect syntax near login

when I am trying to rename the sa account back using this command :

sqlcmd -E -A -Q"alter login sysdba1 with name = sa"

getting error as incorrect syntax near login

Not sure...

Thank you for the reply

I checked everything and tried again but not able to run the script to alter the sa login name

Please help me in getting tht in correct...

Thank you for your reply !!

I was able to start the named instance but now I am not able to alter the login name

I mean I getting error while running...