John Mitchell (2/27/2008)

Since a view doesn't...

I have doubt.... Since Stored Procs can have recompiles and then take bad query plans, cant view also have that same issue?

Thx for all the input guys. I did some more digging and figured out what was wrong. Basically 15 minutes back, there was a sudden surge of data request from...

I have seeen something similar to this happen. In this case, it was trying to grant access to a user right after the stored proc executes. What was happening was...

Thx Steve. I am going get on at the Litespeed guys and find out what the heck happened.

No one has seen this error? That is not good for us then

We had one issue like that. Thankfully it was on our test environment. One of our administrators changed some settings on the switch and the switch had to be rebooted.

One...

I agree with Steve here. Before the Check is signed, you might (Might is stressed here) be able to change the user permissions on the objects. There are times when...

Another thing you have to think about is the security. When you want to have ASP pages to execute SQL code directly (Raw SQL) instead of calling stored procs, You...

Still the same risk is there. What if the SAN goes down? Thats why I prefer to have the Back up on a seperate server that is not connected to...

Hey Adam,

That looks cool. I tried it out and works good.

Brandie, What you say makes sense. My only issue is that there are some IT Managers who think that the System Adminstrators should be able to maintain and take care...

Schema qualification..Thats a large topic. But this is what I can say, When executing any stored proc, if you are not schema qualifiying, then you will definetly have a performance...

I can agree...

One thing I say is, I dont need to be Administrator on the DBA Box or the Domain, I can work without it. But I do not want Network Admins...