I can see syntax in execution ? possible ? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

SQL Server 2000 Forums

SQL Server Development (2000)

I can see syntax in execution ? possible ?

Author

Topic

ChrisBr
Starting Member

2 Posts

Posted - 2005-09-13 : 09:09:56

As I can see all syntaxs sql in execution in the bank, mainly in case of conflict of Lock and locate the caused one, using PID

In oracle this features is for tuning ! etc

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-09-13 : 09:13:03

You're going to need a better translater than that

sorry... I can't even tell if that was a question or not.

If you can get it explained a bit better I'm sure someone will answer

Corey

Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-13 : 09:49:39

i think you want to look at SQL Profiler.

Go with the flow & have fun! Else fight the flow

ChrisBr
Starting Member

2 Posts

Posted - 2005-09-13 : 10:19:39

I go to try, is the site of the altavista is worse that my English. I would like to know which syntax or commands of sql are in execution in the server mssql. To try to discover in which point my application is stopping the bank with locks

Cristiano
São Paulo, Brasil

I found the SQL Profiler, more than where it to extract the information, which the command to twirl in sql to analyzer or SP,

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-13 : 12:48:19

1. run the Profiler
2. click new trace icon
3. choose a server toperform the trace on
4. choose a template (default is ok to start with) and run it.
5. BOL has more information on different templates and other things in the Profiler.

Hope this helps you.

Go with the flow & have fun! Else fight the flow

mmarovic
Aged Yak Warrior

518 Posts

Posted - 2005-09-14 : 04:07:14

DBCC INPUTBUFFER (spid)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources