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.
| Author |
Topic |
|
natas
Yak Posting Veteran
51 Posts |
 Posted - 2005-06-11 : 07:16:16
|
Hello.EXEC sp_monitorthis returns statistics of the SQL-server. But, it returns 4 resultset  , i want to return just 1 resultset with ALL of the columns in 1 table.. anyone know how to accomplish this?. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-11 : 07:24:27
|
| Examine the code in sp_monitor, and copy the section(s) you need to provide that resultset. Make sure to leave the original sp_monitor intact. |
 |
|
|
natas
Yak Posting Veteran
51 Posts |
Posted - 2005-06-11 : 07:47:40
|
| AAh, ok i understand. but, how do i return the SP code so i can see it?. I dont have SQL Query analyser.. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-11 : 08:33:02
|
| What are you using to run sp_monitor if not QA?Whatever you're using, you can run sp_helptext 'sp_monitor' and it will return the code for it. |
|
|
|
natas
Yak Posting Veteran
51 Posts |
Posted - 2005-06-11 : 08:36:27
|
| Yepp , im using a textbased query program, i tried the sp_helptext and it worked fine :)thanks!! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-06-11 : 17:34:16
|
You should really install SQL Server Query Analyser if you are doing much work with SQL Server. I believe the personal edition of SQL Server is around US $50.quote:
Originally posted by natas...Yepp , im using a textbased query program...
CODO ERGO SUM |
|
|
|
|
|
|
multiple result set to 1 resultset