Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 can you debug a stored procedure?

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2011-11-09 : 14:01:01
would be nice.

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-09 : 14:09:35
Yes, I can

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2011-11-09 : 14:18:11
Oh you are from New Jersey, that explains.
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2011-11-09 : 14:24:57
Yes you can. A simple search goes a long way:

http://support.microsoft.com/kb/316549
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-09 : 16:00:09
quote:
Originally posted by AdamWest

Oh you are from New Jersey, that explains.



You gotta a problem with that?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-09 : 16:01:47
quote:
Originally posted by Lamprey

Yes you can. A simple search goes a long way:

http://support.microsoft.com/kb/316549




Yeah, but why bother...Mr. Bat Dude, what do you need help debugging?

Lots of Goto's and Returns???



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2011-11-09 : 17:34:26
Yes I have a problem with unneeded rudeness by your earlier post.
This is a forum for 'new to sql server programming'.

Perhaps think about that.
People come from other systems where they could do that in the query language. Yes I have a problem with your negativity and wasting my time.

You don't have an answer then don't post anything that is all you have to do.

quote:
Originally posted by X002548

quote:
Originally posted by AdamWest

Oh you are from New Jersey, that explains.



You gotta a problem with that?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/




Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-09 : 20:53:56
You need a thicker skin...

And you don't get it..about the Jersey thing...

In any case..sorry if I ruffled your feathers in the past...

you post a very simple question, AND I answered it truthfully

I don't need no stinkin badges..umm tools to debug code

It seems that you are the guilty one here of lashing out

I don't care, if you have a problem why don't ask what the real problem is

If you want a debugger, YOU Could have Google the damn thing

BUT The point IS, you DON't NEED ONE

If you try to listen and learn..if not from me, then from everyone else here

Why don't you ask them, "How many people use a Sproc debigger?"

And seriously, I apologize if I hurt yor feelings..don't interpret my playfulness or non-sequitars as being mocking or hurtful..they are just random drival



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-09 : 20:56:13
quote:
Originally posted by AdamWest
Yes I have a problem with unneeded rudeness by your earlier post.



And if you can help me to not be rude, what was it and which post did you think was rude?


EDIT: And I just thought it was funny. And the "Gotta a prob" is a COMMON New Jersey retort after being dissed for ever..."What Exit", etc

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-09 : 21:04:36
Just Curious..do you work in Corporate America?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-11-10 : 03:48:02
quote:
Originally posted by AdamWest

Yes I have a problem with unneeded rudeness by your earlier post.
This is a forum for 'new to sql server programming'.

Perhaps think about that.


Perhaps think about this:

Your original question was asinine.

Your question:

"can you debug a stored procedure?"

Well the answer to that is only either "yes" or "no", although I might assume that you wanted to know "How to".

Brett answered "Yes". He's like that ...

But you then said "Oh you are from New Jersey, that explains."

So ... the "rudeness fault" starts with you.

Either you can explain the problem that you are trying to solve in enough detail for people to help you, or you can't be bothered. If you can't be bothered some people may try to anticipate your actual question - the upshot of that is that they will frequently find they wasted their time answering the wrong question, and they will get fed up and stop answering vague / asinine questions, and/or avoid answering any questions from such people.

The advice here is free, spend YOUR time carefully describing your problem in enough detail for people to be able to give you some sensible advice, or don't expect any useful replies.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 04:13:29
you can debug stored procedures like below

http://blogs.msdn.com/b/billramo/archive/2009/04/11/transact-sql-debugger-for-sql-server-2008-part-1.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2011-11-10 : 09:14:43
Thank you Visakh. ALot of you may not know that on other systems,
it is possible to debug the query right in the query so that was all I was asking. Perhaps my mistake was in mixing my background of the 2 systems, where probably 99% here have never even heard of CL (Control Language). In the past 3 years I have asked many questions, most of them are on target (for a newbie). it is not a crime to be still on the status of a newcomer, when one is ultra busy with production work. I do apologize for stepping out of line on this thread, it is rare for me. I do see the humor in the posts now, but at the time, I was under tremendous pressure as something needs to be deployed to customers and I am holding it up with a sp that doesnt compile. Please understand the pressures some people are under.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 09:33:30
quote:
Originally posted by AdamWest

Thank you Visakh. ALot of you may not know that on other systems,
it is possible to debug the query right in the query so that was all I was asking. Perhaps my mistake was in mixing my background of the 2 systems, where probably 99% here have never even heard of CL (Control Language). In the past 3 years I have asked many questions, most of them are on target (for a newbie). it is not a crime to be still on the status of a newcomer, when one is ultra busy with production work. I do apologize for stepping out of line on this thread, it is rare for me. I do see the humor in the posts now, but at the time, I was under tremendous pressure as something needs to be deployed to customers and I am holding it up with a sp that doesnt compile. Please understand the pressures some people are under.


You're welcome
Thats ok Adam
Every body have their bad moments. Now that its over dont worry over it. leave it behind and get on with the game

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-11-10 : 09:36:03
quote:
Originally posted by AdamWest
I do see the humor in the posts now, but at the time, I was under tremendous pressure as something needs to be deployed to customers and I am holding it up with a sp that doesnt compile. Please understand the pressures some people are under.



Did you ever get it to compile? Your fastest way would have been to post the sproc with the error you are getting.

DO that still if you still can't get it to compile.

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2011-11-10 : 11:43:32
thank you its ok now.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-10 : 13:26:10
quote:
Originally posted by AdamWest

thank you its ok now.




------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2011-11-10 : 14:00:16
Yes Brett is from NJ.

But considering the thousands of individuals he has helped on this forum (including myself).
We don’t hold that against him. LOL


Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -