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
 How to learn running stored pocedure

Author  Topic 

kcanakli
Starting Member

8 Posts

Posted - 2012-02-04 : 02:17:52
How can I learn running stored procedure name ?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-04 : 02:42:33
sys.dm_exec_requests cross apply sys.dm_exec_sql_text

--
Gail Shaw
SQL Server MVP
Go to Top of Page

kcanakli
Starting Member

8 Posts

Posted - 2012-02-04 : 02:54:19
how can I use
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-04 : 06:11:12
Can you be a little more specific as to what problem you're having?

Those are a view and a function, so they're queryable. Try it out and see.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

kcanakli
Starting Member

8 Posts

Posted - 2012-02-11 : 02:08:50
we use erp programme. erp's all action with stored procedure. I want to learn which action running which procedure. for example
which procedure name running when I click invoice save button
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-11 : 09:29:02
You would have to open the code, or, ahem, go look at their technical specs....

ok..you can laugh out loud now

best way is to do a profile trace and log your actions and make sure you are the only one on the server



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
   

- Advertisement -