Viewing 15 posts - 661 through 675 (of 824 total)
are you using tblxxx as a kind of temp table?
February 10, 2005 at 3:01 pm
Yes, that's my point. What if the INSERT fails? The UPDATE still happens but you will now be setting the addressID in tblSponsor to NULL.
February 10, 2005 at 2:17 pm
Do not neglect the error checking and transaction control. If the first insert fails for some reason, your code would still attempt to update tblSponsor.
February 10, 2005 at 1:11 pm
Try something like this...although I still think it's not a smart thing to split your addresses off like this given what you've said about the subject.
CREATE PROCEDURE dbo.Sponsor_Create_Address
AS
SET NOCOUNT...
February 10, 2005 at 12:58 pm
It all depends on the situation. If you have no choice but to have IIS and SQL on the same box, and can't upgrade the box, then you have to...
February 9, 2005 at 10:49 am
The easiest way is to use Enterprise Manager, right click on your server name, go to properties. Click on Processor and then you have a listing of available processors. Just...
February 8, 2005 at 1:34 pm
ALTER DATABASE tempdb
REMOVE FILE templog2
where templog2 is the logical name of the extra log file, not the physical name.
February 8, 2005 at 1:27 pm
This may not be a bug at all. If you are running a fairly "large" transaction; say updating all 10000 rows at a time, there might not be enough room...
February 8, 2005 at 1:15 pm
Just one last thought... I will reiterate that if I were in your place, I'd be calling MS. At $250 per incident (worst case) it probably doesn't take much of...
February 8, 2005 at 1:06 pm
I didn't really "rule out" a problem with the log file, but it seems doubtful since you would expect to see a host of other problems if that were the...
February 8, 2005 at 12:24 pm
I have never seen anything like this in nine years. The only things that I've seen that could explain this is either the compressed volume thing (although you wouldn't see...
February 8, 2005 at 12:03 pm
What is the point of splitting off the addresses into a seperate table? If each sponsor can have only one address then it is an attribute of the sponsor and...
February 7, 2005 at 4:32 pm
I don't believe the BCP has a published limit to the number of rows it can handle. I know that I have used it to handle a table with over...
February 7, 2005 at 4:02 pm
Run the following query on your server:
select serverproperty('IsClustered')
If it returns 1 you have a clustered server. If this is the case there are several steps you need to take to...
February 7, 2005 at 3:42 pm
Is this by any chance a clustered instance?
February 7, 2005 at 2:43 pm
Viewing 15 posts - 661 through 675 (of 824 total)