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 |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2007-08-20 : 06:20:15
|
| Hi gurus Please help me to get out the problem ... i wanna store the output of SP_MONITOR into a table. Please let me know how can i do this Thanks & RegardsChander |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-20 : 06:30:32
|
| As it returns multiple resultsets you cant store the result in a tableMadhivananFailing to plan is Planning to fail |
 |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-08-20 : 06:36:56
|
| Can u please tell me any other way to do this task. My main aim is to gather system level info in a table.Please tell me the procedure to do this Thanks & RegardsChander |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-20 : 07:18:41
|
| create YourTable (columns that will be returned by your sproc)insert into YourTable (columns)exec sp_monitor_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2007-08-20 : 07:21:30
|
| HiLet me try this create table procedureThanks Chander |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-20 : 08:22:19
|
quote:
Originally posted by spirit1
create YourTable (columns that will be returned by your sproc)insert into YourTable (columns)exec sp_monitor_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp
provided sp_monitor should return single resultset  MadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
insert output of SP into table