When I have linked to Oracle servers in the past I always used the OEM Oracle client driver rather than Microsoft's. I have never run across issues with ASCII translation,...

I saw the same thing happen yesterday, when trying to output to a text file from the cmd prompt or from xp_cmdshell. I am beginning to think this is a...

first of all, thanks for the input rudy

I have tried the different iterations that you described above without sucsess. I do have some differences in environment that may be causing the...

rudy,

did your QA happen to be local to the SQL Server, or was it on a remote client? Interesting.

As a test, I re-installed setspn to c:\. It had the same result. From what I can see, this is the expected behaviour of setspn when called from xp_cmdshell. While...

I have tried passing a param into the exec command without success. I get the same null row as a return. I have studied xp_cmdshell, and realize the power it posseses,...

perhaps the sql service account does not have log on as service rights in the local system policy?

hth

I have not done it that way in the past. I create the new DB environment, create blank databases and restore the database from the lite speed backup. you will...

Wow....

That is alot of stuff. Looks like I will be building a test domain for this one.

Thanks.

For what it is worth, when an intergity check is performed, the database goes into single user mode. I personally would not include an integrity check in a backup maintenance...

I had a situation where i needed to cycle through active connections to any particular database and kill the connection for scheduled maintenance weekend integrity checks. I found that dbo.sysprocesses...

"you should know that there should be NO potential bad news if you kill one in the middle because if it didn't commit it will be rolledback! that's ACID."

Ah, I...

i would definitely try to reindex the database. Not on prod though!!!

eventid.net might have some more detailed info on your error as well.

Thanks for the input Wesley. I have already built the mechanism to kill the spids as detailed in the code below. What I am really after now is a way...