Depends. One of the biggest things you should try to avoid is using tables simple because you don't want to add to drive access if possible. I would use declared...

quote:

---

How do you get the value of a particuilar column of the currently updated row.

---

...

PK to FK constraints are handle quite well with cascade but you should make sure to test the effects for you setup before you put in production.

"Don't roll your eyes...

Most of the tools I have seen either are for hardware or capture queries to play back to the server which profiler can do. Best I have ever done to...

After a raiserror you must issue a return.

Ex.

if @str IS NULL

BEGIN

RAISERROR('You must enter a search string',16,-1)

RETURN

END

RestOfCode...

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Has to be some sort of rights issue with either your client or the way SQL accesses your box. This is the checklist of items from Microsoft one the configuration,...

I have seen some odd errors with SQL in regards to outputs and number levels. Not heard of anything like this being a problem here but some things to check...

Note on app security when embedding the password to a single account inside. If you are real concerned with security a few things to keep in mind about apps are...

Don't know of a specific product as most I have seen are specific to a particular database. Whatare the two sources and how do you want to do it based...

I do believe the log files verify commited transactions so that a file can be restored idenpendently. However I have not tested and just cannot do so right now. Test...

Well that would at least explain the 2 Gb's free. Check out what all SQL is doing and looking and task manager how sharp did the memory climb (fast or...

Ok I have never worried about this since after my last differential for the week I truncate the logs anyway. However I keep hearing and too myself thought the Log...

Also make sure when you add them back add the clustered first then non-clustered. Reason is every time a clustered index is dropped and added all existing non-clustered indexes are...

The a combo change of both of our codes should help.

SELECT

*

FROM

(

SELECT

[No],

ITEMCODE,

AMT,

AMT + (SELECT ISNULL(SUM(AMT),0) FROM Sl iT WHERE iT.AMT > oT.AMT AND iT.SL_NO > oT.SL_NO) as cummulative

FROM

Sl oT

)...

Not sure if you did this setting but from SQL BOL /3GB swtch parameter info

Using AWE Memory on Windows 2000

Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000...