are you using database mirroring? and if so what service pack are you on ?

sorry - its a bit difficult to diagnose without being able to actually get my hands on the system.

as was posted earlier by someone else - have a look at...

GilaMonster (5/17/2012)

---

Please do not suggest that people...

adrian.sudirgo (5/17/2012)

---

michael vessey (5/17/2012)

---

apologies - i didn't read your post correctly 🙁

how...

apologies - i didn't read your post correctly 🙁

how about the inbound...

have a look at this article on troubleshooting service broker

http://www.sqlteam.com/article/how-to-troubleshoot-service-broker-problems

look in sys.transmission_queue

these should be messages that coudn't be delivered may be they are re-trying ?

tempdb is used to store temporary tables and data related to sorting (amongst other things)

if your insert required some kind of sort then it's possible tempdb would be increasing -...

you are migrating data from Access to SQL server - use the ACCESSS TO SQL SERVER MIGRATION WIZARD

interestingly enough i tried another workarount using a CTE.

it works fine every time - saves you having to use a temp table

🙂

as for whether it's a bug or not, well...

i also tested it though a cursor and the cursor worked fine...

interestinigly - if you remove the order by clause then the query also works - very frustrating

i've been...

i took the data from the query into a temp table and then did the

select @sql=@sql+mytext from #res

print @sql

works fine

if you take out the assertion and just return a recordset it works fine - i can't see why the top clause if affecting you when concatenating into a string

initially...

nguyenhoang 18993 (5/17/2012)

---

how are you determining that the trigger did not fire ? - have you run a profiler trace to determine the data that was inserted?

No! if I action...

there seems to be some syntax issues in your code

Msg 156, Level 15, State 1, Line 28

Incorrect syntax near the keyword 'DESC'.

i think it's a cut and paste issue