Sounds about right for a new record.

You've been there for 6+ days.

I'd have queried the tasks wait to see if something was slowing the rollback down. You can still do it but I'm 99.999% sure...

Ya, can't rekill it.

Cycle the server will complete the rollback (if not done now). Of course the db won't be available at all during that time (which as a...

Looks like from the previous posts that you need to add another EXEC() after the use.

A freakishly a$$ long time.

If the server is slow, maybe 1 month.

Change GO for ;

Sean Lange (10/13/2011)

---

Uripedes Pants (10/13/2011)

---

Sean - yeah, my company is going through some growing pains getting rid of some end user developed Access DB's. (We are actually a large agency...

Just add a GO on the line before the CREATE TRIGGER.

Uripedes Pants (10/13/2011)

---

Sean - yeah, my company is going through some growing pains getting rid of some end user developed Access DB's. (We are actually a large agency that is...

This is a good read for the fill factor issue => http://www.sqlservercentral.com/Forums/Topic1126147-146-1.aspx

Edit, yes you can start all the jokes you want about infinite loop & recursion :w00t:.

Note the edit a...

I'd actually restore prod right now on a test...

GSquared (10/13/2011)

---

Ninja's_RGR'us (10/13/2011)

---

GSquared (10/13/2011)

---

Ninja's_RGR'us (10/13/2011)

---

GSquared (10/13/2011)

---

That'll work. Might end up with problems in terms of cached execution plans being good for one or the other but not both, and...

Uripedes Pants (10/13/2011)

---

SSRS is only equivalent to Access reports - and from what I've done so far, it's kind of clunky but that's probably my lack of experiance.

SQL Server has...

GSquared (10/13/2011)

---

Ninja's_RGR'us (10/13/2011)

---

GSquared (10/13/2011)

---

That'll work. Might end up with problems in terms of cached execution plans being good for one or the other but not both, and so on.

You...

Uripedes Pants (10/13/2011)

---

OK... gotta add my 2 cents.

To the Original poster - someone else has already mentioned calling the stored proc using dao/ado in Access. The sp...