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 |
|
msmith_lv
Starting Member
2 Posts |
 Posted - 2007-10-19 : 11:56:34
|
| I have several hosted websites using MS SQL Server 2005 and ASP.NET 2.0 set up as DotNetNuke portals. I need to do a minor patch in a stored procedure to fix buggy functionality in one module. I have the patch, but what do I need to install on my local machine in order to edit the stored procedures on the hosted database?The hosting company's support said to install SQL Server Management Services (SSMSEE.msi), but the install fails giving a link to a pre-requisite component called ADOMD.msi. That one seems to install okay, but I still get the same error when trying to install the Management program. Perhaps I need SQL Server Express on my local machine? I'm really just looking for the best way to access and edit stored procedures on my hosted database?I would REALLY appreciate a nudge in the right direction...?Thanks.Michael E. Smith |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-19 : 12:23:46
|
| Yes, if you install the client tools of SQL Server express , then as long as you have the right connection paramters , you should be able to access the hosting service to modify your stored proceduresJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
msmith_lv
Starting Member
2 Posts |
Posted - 2007-10-19 : 14:18:47
|
quote:
Originally posted by jackv
Yes, if you install the client tools of SQL Server express , then as long as you have the right connection paramters , you should be able to access the hosting service to modify your stored proceduresJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Okay, I think I can handle that. Thanks much!!-Michael |
|
|
|
|
|
|
Accessing Stored Procedures on Hosted Server