Its really very very useful video. please provide us using within another stored proc to debugging. It will very useful us. Thank you so much for your dedicated vedios
I have been able to connect to the server with some extra firewall and user profile settings and I can also see the stored procedures, but when I select 'debug procedure' it does not stop with the yellow date like in the video, it executes and returns the result directly. Are there any extra settings missing?
Hi @Learn SISS, Thanks for the debugging video. Just a question we can not run this technique directly in the production env as by this we are executing the proc.
I'm getting 'Failed to start debugger. an exception was generated: Data is Null.This method or property cannot be called on Null values.' your quick reply saves me a lot
Hi@@priyagowri96 , I don't too much debug the sp thus I don't normally get this kind of errors. I googled your error and found that maybe you can download and install an older version of ssms to debug the sp stackoverflow.com/questions/53596146/how-to-debug-stored-procedure-on-microsoft-sql-server-2017
Did F10 working ? Sometimes Keys are not by default configured correctly for this. I mean for different models of laptops these function keys sometimes works differently. If you have function key on your laptop then Press Funtion key + F11 together.
Hi, I read they removed these features because it was too tightly coupled with MS Test. Other simply say it is related to low demand. But this is problematic. I am working for a client which intensively writes stored procedures. We as devs have little to no rights to do a few simple things such as create diagrams or use SSDT. I would personnaly love to debug step by step just like when I code C#. T-SQL is not my greatest skill so such tool could really help understanding and also checking to get confidence in the code as it executes or identify precisely what would be wrong.
Yeah, If the debugging was available in SSMS then it would be easy for developers to debug any code similar to C# debugging from the same app in which we are working.
Nice basic tutorial. I know English is a second language for you, so just an FYI, you punctuate your sentences with the word 'okay'. So as an example, "Then you hit F11...okay" "If you want to step over hit F10...okay". Americans and Brits can find the unnecessary 'okay' annoying 😀
Please make a video on
Partition table
Its really very very useful video. please provide us using within another stored proc to debugging. It will very useful us. Thank you so much for your dedicated vedios
yeah that will also be great to make another video where we call one stored procedure from another and we go into the second stored procedure.
@@learnssis we are eagerly waiting for more videos, thanks again😊
I have been able to connect to the server with some extra firewall and user profile settings and I can also see the stored procedures, but when I select 'debug procedure' it does not stop with the yellow date like in the video, it executes and returns the result directly. Are there any extra settings missing?
This is exactly what I was looking for, thanks bro. Good video
Thank you.
Hi @Learn SISS,
Thanks for the debugging video.
Just a question we can not run this technique directly in the production env as by this we are executing the proc.
yeah running this in production might not be a good idea.
your way of teaching is amazing, thank you! (watching from sweden)
Thank you Sir. Glad to know that you liked the video.
Thanks for your time I am watching from #Adelaide #Australia as a Database Engineer
Glad you found the video helpful.
Hello can you make video on power apps
What are power apps 😄
excellent bro, i was looking for solution like this. Thanks
Glad you found the video helpful.
Hi Aqil, Could you please make a videos on stored function and how it works in real time project
Yeah I will make videos on functions as well for sure.
I'm getting 'Failed to start debugger. an exception was generated: Data is Null.This method or property cannot be called on Null values.' your quick reply saves me a lot
I'm doing in virtual machine
Hi@@priyagowri96 , I don't too much debug the sp thus I don't normally get this kind of errors. I googled your error and found that maybe you can download and install an older version of ssms to debug the sp
stackoverflow.com/questions/53596146/how-to-debug-stored-procedure-on-microsoft-sql-server-2017
Thanks for making
Everything is easier ❤
Thank you Tech Priya.
Which version of visual studio it is?
This is Visual Studio 2019, however you can try any version.
Excellent video, it helps me a lot
Glad you liked the video.
Nicely explained. Thanks!
Thank you.
Thank god, it popped up in my recommendation page
Thank you Heathen.
Hello Aqil,
Can you please put your LinkedIn profile in the video description link?
Here is my linkedin profile. I am not very active on linkedIn though.
www.linkedin.com/in/aqil-ahmed-01628058/
I press f11 but it is not going to sp just run exec statement
Did F10 working ? Sometimes Keys are not by default configured correctly for this. I mean for different models of laptops these function keys sometimes works differently. If you have function key on your laptop then Press Funtion key + F11 together.
Hi, I read they removed these features because it was too tightly coupled with MS Test. Other simply say it is related to low demand.
But this is problematic. I am working for a client which intensively writes stored procedures.
We as devs have little to no rights to do a few simple things such as create diagrams or use SSDT.
I would personnaly love to debug step by step just like when I code C#. T-SQL is not my greatest skill so such tool could really help understanding and also checking to get confidence in the code as it executes or identify precisely what would be wrong.
Yeah, If the debugging was available in SSMS then it would be easy for developers to debug any code similar to C# debugging from the same app in which we are working.
This will be very useful thank you for video!
Thank you Bryan.
very informative, thanks you so much😊
Thank you Gowri.
Great video!
Thank you Zenish.
pls create one complex SP and explain in detail, please...if you know telugu pls explain in telugu
Yeah I will create some complex sp, sorry I don't know telugu.
The example could have been different
Good video
Thank you.
Thanks bro
You are most welcome.
Thanks
You are welcome.
excellent
Thank you Frank.
Good
Thank you.
Nice basic tutorial. I know English is a second language for you, so just an FYI, you punctuate your sentences with the word 'okay'. So as an example, "Then you hit F11...okay" "If you want to step over hit F10...okay". Americans and Brits can find the unnecessary 'okay' annoying 😀
Thank you for your suggestion. yeah I know my English sucks :)
@@learnssis No, it's not bad, just a few rough edges to iron out 😀
@@MB-ub5ns Okay 😀