Adding Stored Procedures

My web application requires the stored procedure [master].[dbo.[xp_md5]. with the hosting package and the sql 2005 database addon, i was not aware that access to the master database would be restriced is there anyway to install this stored procedure in a client database and have the application be able to use it there instead of in the master database? im sure this question is not worded very well, but frustration makes it hard to think at times.. any help here would be greatly appreciated

thanks

 

Hi,
Unless a reference to that SP is in a binary in your/bin/ folder you should be able to edit any reference.
The SP can exist on your default DB.
Often you can simply remove the referenced DB, i.e. master, your account will use the default.
Salute,
Mark

 

Im a bit more lost then the original poster, but I think Im in the same ballpark.


When working with Visual Studio Express offline, there is a folder where you save stored procedures. I am accessing the SQL 2005 server on DASP through MS SQL Server Management Studio Express 2005, and when I run down to my database, I see a couple of folders (including Tables), but I dont see a place to save stored procedures.


What am I missing?


Thanks.

 

Hi,
I've attached an image that shows where you will see your Stored Procedures.

They are not shown unless you expand the Programmability section.
If you need more help let me know.
Salute,
Mark