DB2 adopts UNICODE by default. Hence the column which was declared as CHAR(1) has become CHAR(4) to accommodate the UNICODE characters. Hence it is throwing an error.

Is there a way...

Thanks for your quick reply.

I will try the master stroke solution for MS products 🙂 a restart might help.

Four part shouldn't be an issue as the queries used to...

The issue is sorted now.

The firewall for the exchange server was not allowing the mails to be delivered.

It is delivering mails to public mails like Yahoo and Gmail.

I am using the full email address, like abc@gmail.com

The description is all NULL for all the entries.

The message status is showing as sent.

I have already checked the junk mails. It is not there

Please let me know need if you need any other information to help me to solve the problem.

When I execute the following query:

select * from sysmail_allitems

where subject like '%word%'

order by last_mod_date desc

I found the status is showing sent. But no mail is delivered to the email...

Hello,

The following is the code for sending mail:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Profile Name',

...

Yes, I can send it from Database Mail > Send Test Mail

I stopped the browser serice and connected to the server.

Then I started the browser service.

It worked for me.

Thanks for your help

I have restrarted the server and the services has started now.

I connected to the instance.

But when I am trying to open Properties of the instance I am getting the following...

Thanks Gail for the quick response.

But since the script is running fine in production why is creating such a mess in Development?

This issue is for SQL Server 2000

Thanks Gail for your help.

Is there anyway to take a backup, eliminate the space while restoring the database?

Soory for the inconvenience.

I have followed the following steps:

Tasks-> Shrink -> Files

Select a data file(.NDF) of Primary file group.

Select radio button for :

Reorganize pages before relaesing unused space

Shrink file...