Viewing 15 posts - 38,206 through 38,220 (of 39,804 total)
March 1, 2002 at 11:17 am
Another apology. Not that much of a web guy. You might try posting this at 4guysfromrolla.com and seeing if they have an idea.
Steve Jones
March 1, 2002 at 11:16 am
update cd
SET TotalPaidIn = TotalPaidIn + cp.receiptamount
, BalanceOnHand = BalanceOnHand + cp.receiptamount
from casedata cd
inner join currentpostings cp
on cd.casenumber = cp.casenumber
WHERE cp.batchid = @batchid
Steve Jones
March 1, 2002 at 11:14 am
Tend to agree with Antares. If these are different development efforts, might be easier to have one server with mutliple databases. Less admin and licensing as well.
Steve Jones
March 1, 2002 at 11:11 am
March 1, 2002 at 11:10 am
Tend to agree with Andy. I usually make a role as soon as I create the database for the general access for that database. Might be webusers, might be MyAppUsers,...
March 1, 2002 at 11:09 am
Haven't seen anything specific to deadlocking. Part of the problem is that you need to capture the events up to the deadlock to track it down, not once the deadlock...
March 1, 2002 at 11:07 am
February 28, 2002 at 5:04 pm
Have you rebooted and restarted? I thought this was the service account not having permissions.
Steve Jones
February 28, 2002 at 3:21 pm
February 28, 2002 at 3:05 pm
February 28, 2002 at 1:40 pm
The stored procs and views, etc. will mostly run in memory, so more is better. You can separate the data, however, using filesgroups and place heavily used data on separate...
February 28, 2002 at 1:38 pm
Haven't tried it, but I have seen others report errors. SQLMaint seems to be, imho, not a really solid piece of code.
I implemented my own with DTS where I http://ftp...
February 28, 2002 at 12:28 pm
Viewing 15 posts - 38,206 through 38,220 (of 39,804 total)