I'm a forty-something Microsoft SQL Server DBA of 12+ years, a devoted husband, and a father of two young boys (with another coming soon!). I have been a DBA at a university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States.

"BUG: You receive an "Error 14269" error message when you try to modify the SQL Server Agent job if the combination of the computer name and the instance name is more than 30 characters in SQL Server 2000"

I had noted that the instance I was reviewing is a named instance with a long name, which is annoying for my lazy typist side but just a reality of how this older system was set up.

According to the SUpport KB, there was apparently a bug "by design" in the sp_add_jobserver stored procedure whereby the servername (Server\Instance) is processed as an nvarchar(30) parameter, which does not work with the long servername.

What made me laugh out loud was the number one workaround in the Support KB:

Since I was pretty sure I couldn't re-install the aged server, I went with option 2 and scripted the job to drop and re-create with the new schedule.

----

I realize that in the year 2012 the odds that someone else out there is running SQL 2000 with a greater than 30 character server name is slight. but if you are out there, hopefully this will help!