Viewing 15 posts - 376 through 390 (of 1,065 total)
The trigger fires only once per INSERT statement received by the database.
So, if your application is generating 1 insert statement for each row the user selects from the GUI, then...
October 7, 2009 at 4:22 am
If I'm right in what I think you are trying to do, then either you are testing against the wrong table or you don't have the correct concept of when...
October 7, 2009 at 4:03 am
So you actually have a many to many relationship between a dealer and a vehicle. Therefore, isn't a claim related to the DealerVehicle entity, not the vehicle itself?
Manufacturer
...
October 7, 2009 at 2:18 am
If you use the system stored procedures sp_change_primary_role and sp_change_secondary_role to switch the roles in the first place, and then use them to reverse the roles when you have finished...
October 7, 2009 at 1:57 am
A vehicle has one dealer (IssueDealer).
A claim belongs to a vehicle.
A claim has one dealer (RepairDealer).
That sounds like you have circular relationships.
If a claim belongs to a vehicle, and a...
October 6, 2009 at 8:28 am
There are a lot of things to consider before coming up with the right data model for this... for a start
Do dealers actually belong to a manufacturer... in the UK,...
October 6, 2009 at 7:13 am
A word of warning about using DELETE CASCADE if you are using transactional replication.
I don't know if this is still relevant to SQL 2005, but it certainly happened in SQL...
October 6, 2009 at 4:02 am
Jeff Moden (9/17/2009)
October 6, 2009 at 3:50 am
Don't compromise the design of your database just to have fewer tables and make the SQL easier/shorter... you will just be storing up problems that will have the potential to...
October 6, 2009 at 3:06 am
If the following is true...
A Market can have many Products, but a Product can be in only one market
A Product can have many Models, but a Model can be in...
October 5, 2009 at 7:15 am
tvantonder-992012 (10/5/2009)
Not the server name itselfs. Is this possible with Network??
Yes it's possible.
Run the client network utility from the machine where you are seeing the 2 instances and have a...
October 5, 2009 at 4:31 am
I can't see your screenshot... but it's possible to create an Alias for a server (using the client network utility) so you can refer to the same instance using multiple...
October 5, 2009 at 3:41 am
As has been said, without backups, the SQL Server route is going to be a dead loss.
If the log reader suggestion doesn't work, then it may be worth trying some...
October 5, 2009 at 3:00 am
Um, no. The view only selects rows with an active domain, IsActive is a fixed value for these.
I must be having a "senior moment", but I still can't work it...
October 2, 2009 at 11:40 am
Mark-101232 (10/2/2009)
CREATE VIEW dbo.ActiveDomainNames
WITH SCHEMABINDING
AS
SELECT DomainID,AffiliateID,DomainName,CreatedDate
FROM dbo.MyTable
WHERE IsActive=1
CREATE UNIQUE CLUSTERED INDEX ix ON dbo.ActiveDomainNames(DomainName)
I see the idea (very neat), but can't figure out how that would limit it to a...
October 2, 2009 at 10:49 am
Viewing 15 posts - 376 through 390 (of 1,065 total)