Viewing 15 posts - 2,311 through 2,325 (of 7,429 total)
I think I understand here, however are you attached to your structure and I believe I can offer a simpler, cleaner solution?
February 11, 2004 at 6:28 am
I notice your path mssql7 which suggests you are using SQL 7. There is a known issue with trying to shirnk the log files related to the virtual logs not...
February 11, 2004 at 6:28 am
The more jobs you have (even for replication) on a server and the more times they run means the more overall lines that are written to the log. There is...
February 11, 2004 at 6:20 am
Ok first off we haven't really decided it is a permissions issues that is the cause of the failure. Then message you see is normally longer in the Job History....
February 11, 2004 at 6:18 am
Triggers fire per transaction not per record. WIth the INSERT...SELECT the whole piece is one transaction which means all the items are in the inserted table at one time when...
February 11, 2004 at 5:59 am
They were last I looked but if you cannot find I should still have a copy on CD here, let me know.
February 11, 2004 at 5:53 am
Using Enterprise Manager drill thru the treeview side to the SQL instance you want to review. Then drill down thru that instance thru Management to SQL Server Agent. From there...
February 11, 2004 at 5:52 am
The problem is the way your flagging mechanism works you have time for new records to enter without being seen. I suggest using a 3 value flag. Like so
UPDATE MYAccess...Answers...
February 11, 2004 at 5:46 am
I see you state you already have a coulmn with autonumber in it.
How are your inserts done. Direct insert statement, select insert statement, wrapped in Stored Procedure or some other...
February 11, 2004 at 5:38 am
Just noticed. Please do not cross post. Related thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=99613&app=true
February 11, 2004 at 5:36 am
Just noticed. Please do not cross post. Related thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=99652
February 11, 2004 at 5:35 am
What Service Pack is installed on the SQL server? I seem to recall something along those lines fixed in SP 3 or 4 but I don't fully recall.
February 11, 2004 at 5:32 am
Yeah the message about not being implemented is interesting, but so far MS hasn't committed to implementing in SQL, not sure on Yukon as I haven't had time to get...
February 11, 2004 at 5:30 am
Actually you shouldn't have to. ALl the items from the insert batch you do should exist in the inserted table for the event.
Try this
TRIGGER trigger1 ON table1
INSTEAD OF INSERT
AS
INSERT INTO...
February 11, 2004 at 5:05 am
The character face should be a ) not the face, replace it within the code and should work right.
February 10, 2004 at 4:56 pm
Viewing 15 posts - 2,311 through 2,325 (of 7,429 total)