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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2006-12-13 : 15:50:23
|
| Hi, I have opened up a stored procedure sp_helpdb and modified it as sp_helpdb2 to give me just the name of the database and their sizes.I am trying to use this stored procedure in sql 2005 reporting service to generate a web page with the same information.But the query containing exec sp_helpdb2 does not even compile in the reporting service GUI.Has anybody gotten a simpler script than having to create a temp table and then populating the output of the sp_helpdb into the temp table and then querying the table to display the results? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-14 : 05:55:52
|
| Create procedure help_SPasCreate table #t(...)Insert into #tEXEC sp_helpdb2Select * from #tMadhivananFailing to plan is Planning to fail |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-12-14 : 10:42:57
|
| Madhivanan, I already have this script. The problem is when you use this stored procedure in the reporting services, it does not attempt to create the temp table and the script fails.That was the part of my original post. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-14 : 11:02:49
|
| Then better post at Reporting Services ForumMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Database Sizes on a server