with X (schemaname,tablename,recordcount)

as

(

SELECT s.Name AS SchemaName ,

t.Name AS TableName ,

SUM(p.rows) AS RecordCount

FROM ...

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from table_2 where userid=x.userid and age is...

hiren

i have done this before - there is an option that you can use, but it depends on how much of the data on your POS server is replicated back.

you...

also try looking to see how many conversations are still open

select * from sys.conversation_endpoints

maybe your application is not closing the conversations after the messages.

since you've got nothing on the queues,...

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...