March 15, 2007 at 10:27 am
I installed SP2, then SP2a after the first one I could'nt delete,update any previously created maintenance plan. I hoped SP2a will resolve the issue. Well it didn't. I get the following error when trying to delete or update a Plan. I will greatly appreciate any comment or hint on what it is going on here. The plans run without any problems, bu I need to change the schedule and add new dbs.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
Enumerate target servers failed for Job 'Daily Cleanup-Backup.Subplan_1'. (Microsoft.SqlServer.Smo)
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
String or binary data would be truncated. (Microsoft SQL Server, Error: 8152)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3050&EvtSrc=MSSQLServer&EvtID=8152&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
March 21, 2007 at 5:34 am
I had to re-install SQL 2005 to get rid of this issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply