I tried removing the @OUT is not null and it still didn't work, besides it was checking for not null OR  <> ''.

I was able to resolve the problem by changing the execution of the SP to use ascii(@OUT), as in:

declare @out varchar(8000)

declare @From varchar(200)

declare @To varchar(200)

declare @subject varchar(300)

declare @minimumspace int

set @minimumspace =...

Lowell,

Thank you for your response. I found an undocmented DBCC command that showed me just what you're saying. I ran DBCC TAB for some of the objects and see that...

Yes, I tried that also, but that fails with invalid column name 'A-MSG'.

CDA,

Thanks for the reply. Yes, there is one instance on each side of the cluster. I verified yesterday that the parallel processing was set to all processors in Miami. I...

alzdba,

Not sure I understand your comments. Are you saying it stands to reason the new environment would be slower? If so, right now we have to deal with the hardware...

John,

Thanks for your reply. The databases are setup with auto update statistics. What system table can I check for the last date of the statistics. The optimization task runs every...

How could I test that? I tried already by trying to connect through MS Access with a blank login/password thinking maybe it defaulted to 'Admin', but it showed up on...

Zubeyir,

Thank you for responding, but I'm not sure I understand your explanation. The hostname for the user I was able to contact was his actual client machine not the citrix...

The machines are not in the same domain as the SQL Server. The hostnames are client machines, at least for the one that I was able to contact. The user...

John,

Thanks for the reply. There is no Admin sql server login, so that is why I thought it may have something to do with the Builtin\Administrators account. Below is an example...

SQLRep,

I have setup replication from SQL Server to Oracle. First install the oracle client SQLNet software on the SQL Server machine. Then configure the oracle database as a subscriber. Create...

The database is in simple recovery mode for two reasons. The first is that this is a UAT environment, not production. The second is that the database tables are refreshed...

Thanks for all the replies. The job was failing with unable to extend log due to disk filling up. I think I have solved my problem though. I added a...

The job runs successfully when I right click on it in Enterprise Manager and click start job, but it fails when it runs when scheduled. What could cause that? It...