Tuesday, January 13, 2009

Tip #27 – Get a List of Running SQL Statements

Advantage has many built-in stored procedures, called system procedures, which provide a wealth of information.  These system procedures can provide database information, manipulate database objects and provide management information. One of these procedures retrieves the list of currently running SQL statements. The sp_GetSQLStatements procedure returns the same data you can view o n the Management Utility in ARC.

Running Queries

This statement returns the following information:

  • Query Number
  • Active
  • Percent Complete
  • Connection Name
  • Database User
  • Database
  • Query
  • IsScript
  • Full Script
  • Start Time
  • Seconds Until Finished

1 comment:

Anonymous said...

My name is Vickie Desouza I was browsing internet and found your blog. The author did a great job. I will subscribe to your RSS feeds. Thank you for your contribution. I am a web designer myself. And here some examples of the websites that I designed for loans payday loan company.