I did that.

Table 'tbDataList'. Scan count 1, logical reads 6005, physical reads...

Let me give you the reason why I did not want Shared Storage. We had a SAN Drive and we had cluster on the Production DB. Our SAN failed once...

Isnt there anyone who could advice me on this?

I havent worked with RedGate. We use Lite speed. it is also pretty good at compressed back ups. If you have a new server, I second the idea of Log...

You can Check IsNULL or you could use Case Statement to insert a space when the value is NULL.

homebrew01 (9/23/2008)

Jeff Moden (9/22/2008)

My recommendation is to peel one potato at a time. To know which potato to peel first, you must do some measuring. Put the following...

Is this the output of your response.write?

Update web Set answer11='gerste' where identity=''3597@10P136P12P125''

I see double quotes in the identity part. Check the Identity part. Also if I am not mistaken Identity...

I do not think that it came in as query string. If the page has Input Boxes where customer/user can enter values, then it must have come through there.

I...

That is for that particular DB. You can try to login with the user and do a select on sysobjects. You will see an access denied

You can deny all on any tables that you want for that user.

For example if Test is the web user, then you can do a

deny all on sysobjects...

What kind of Rights does the Web Application User have? Check the rights of the user and remove access to objects that are not needed.

Developers having access to production it self is a bit too dangerous in my humble opinion. You dont know what they will run. You get a Select * with no...

Update A

set a.AudType = b.AudType,

a.AudCompID = b.AuDCompID,

a.AudDate = b.AudDate,

xxx

xxx

xxx

a.ClearedDate = b.ClearedDate

from hist1999 as a

JOIN dailyupload as b

on a.ID = b.ID

Insert into hist1999

(ID, AudType, AudCompID,...

It is way low. The only thing I did not dig into much is is there will be Locking over head when it is trying the Update even though there...

My preference is that the User that connects to the DB from a web application should not be able to do any raw SQL. make sure that the User does...