Debugging Stored Procedures in SQL Server 2005. Posted by Deeraj Chakravarthy under Sql Server category on 11/12/2007 for Beginner level | Views : 147612 If you found plagiarised (copied) or inappropriate content, please let us know the original source along with your correct email id (to communicate) for further action.
Rating: 3.67 out of 5 3 vote(s) Were you ever in need of debugging a stored procedure in SQL Server 2005. Any .NET Developer is well versed with debugging .NET applications. Ooo lala! This article aims at providing an insight into how debugging stored procedures can be configured by a DBA/ Senior DB programmer that makes the job of DB programmers lot more easier. When I say debugging stored procedures in SQL Server 2005 remember am not going to use SQL Server Management Studio. Follow the steps carefully as described underneath. Pre-requisites 1. 2. As a DBA, I may need to grant this privilege to the user who is in need of debugging a stored procedure. The command to do so is as follows Process to Debug a stored procedure. Main Page - MonoTouch from Novell. CIContext *context = [CIContext contextWithOptions: [NSDictionary dictionaryWithObject:[NSNumber numberWithBool:YES] forKey:kCIContextUseSoftwareRenderer]]; CIImage *ciImage = [CIImage initWithCGImage:cgImage]; CIFilter *hueAdjustFilter = [CIFilter filterWithName:@"CIHueAdjust"]; CIFilter *colorControlsFilter = [CIFilter filterWithName:@"CIColorControls"]; [hueAdjustFilter setValue:[NSNumber numberWithDouble:3.0 * M_PI] forKey:@"inputAngle"]; [colorControlsFilter setDefaults]; [colorControlsFilter setValue:[NSNumber numberWithDouble:1.3] forKey:@"inputSaturation"]; [colorControlsFilter setValue:[NSNumber numberWithDouble:0.3] forKey:@"inputBrightness"]; [hueAdjustFilter setValue:ciImage forKey:@"inputImage"]; [colorControlsFilter setValue:[hueAdjustFilter valueForKey:@"outputImage"] forKey:@"inputImage"]; ciImage = [colorControlsFilter valueForKey:@"outputImage"]; [context [createCGImage: ciImage fromExtent:[ciImage extent]]];