Last post Feb 06, 2011 02:20 AM by bobj181
Feb 03, 2011 05:31 PM|asharsyed|LINK
I am getting this error message all of a sudden when I try to debug stored procedure in SSMS.
Data is Null. This method or property cannot be called on Null values. (System.Data).
I have tried it on all the stored procedures that I used to debug before but now it's not working. Any idea why this would be happening, do I need to reinstall Sql Server 2008? Currently I am running MS Sql Server (SP2).
Error details are given below.
Failed to start debugger
Data is Null. This method or property cannot be called on Null values. (System.Data)
at Microsoft.SqlServer.Management.UI.VSIntegration.DebugSession.DebugCallbacks.OnSqlInitializeDebuggingEvent(ISqlInitializeDebuggingEvent sqlInitializeDebuggingEvent)
at Microsoft.SqlServer.Management.UI.VSIntegration.DebugSession.DebugCallbacks.Microsoft.VisualStudio.Debugger.Interop.IDebugEventCallback2.Event(IDebugEngine2 debugEngine, IDebugProcess2 debugProcess, IDebugProgram2 debugProgram, IDebugThread2 debugThread,
IDebugEvent2 debugEvent, Guid& riidEvent, UInt32 attribute)
Feb 04, 2011 05:35 AM|KumarHarsh|LINK
you hv to show ur code .try using isnull.
Feb 06, 2011 02:20 AM|bobj181|LINK
If this happens on all of your queries, then there may be a probably with the install of the instance. I suggest that you take this to a DBA forum as this may be an issue with the SQL Server engine it's self and not how it reacts with ASP.NET.