Problem with job history. sql server 2005

HI

I found some issue with job history. My server name length is 32 charecters. and when we view the job history in sql management studio, some back ground script is running, there microsoft has defined servername as 30, due to this smaller definition for server server variable, i am getting error when i tried to view the job history.

what wil be the solution for this issue?

thanks

kiran

rename the server. hahaha. joke

|||

Hi Kiran,

Thanks for reporting this problem. Please file a bug using the following link https://connect.microsoft.com/SQLServer/Feedback.

Workaround:

Use the following stored procedure to get the job history

exec msdb.dbo.sp_help_jobhistory @.mode='FULL'

Link for more help on the above stored procedure:

http://msdn2.microsoft.com/en-us/library/ms188025.aspx

Regards

Rajesh Basa