This is not a standard phrase. I'm *guessing* that the sprocs would return all the rows affected by any actions it took. This is often easier said than...

Just key it's name in including instance.. That works..

CEWII

First thought is change the default database for your login to something other than master.. Try that..

CEWII

You are very welcome, I lok forward to hearing how it went.

CEWII

So not an ancient box.. That is good.

Thats a...

I have a fair amount of experience with DNN and yes a load on the DB is common. However, the load that you are talking about seems a bit...

sid18in (9/29/2009)

---

Thank you for the replies...

Let me give a background on the system, we have Kentico CMS system which was used to build the website, so for everytime any request...

Unfortuantely I think you are right.. I can't think of another way to get it to work the way you want it to..

CEWII

I agree with Mr. Kelley. You need to control your exposure at this point. I think there is a very high chance of risk and taking the WS...

Do you get a whole bunch or just a couple. Also, the login that your webserver is using isn't a sysadmin is it? Also we set our sa...

K. Brian Kelley (9/28/2009)

---

Elliott W (9/28/2009)

---

Also, you might be able to "hack" sp_password to store the passed in parameters in a table. I have to say I would do...

It could be an attack, and the only way I know to find out what parameters it is using is to use a packet sniffer on the network or the...

I have done it a couple of times and I would start with a server that has as few roles as possible already installed. Don't install anything you absolutely...

Here is your problem:

It needs to include a variable name:

You need to insert the records into that variable..

I can't remember if you need...

sid18in (9/28/2009)

---

Thank you RBarryYoung for your reply,

Yes security is an issue, also the the CPU and Memory contention are my major headaches for me because of which my website is...