Since Steve's post was after the edit, I imagine he's referring to the question as...

It should. No idea offhand why it isn't.

Whoever told you that is mistaken

if this is not so I would love to know...

Does this work?

select top 1 id

from tblname

where tblname.person = 'xxx-xxx...'

group by id order by max(dttm) desc

I see why.

It's the insert into A straight after the creation of the temp table. That forces a recompile of the entire proc (because the temp table didn't exist when...

Script looks fine. The SQL service has to be restarted for this to take effect. Until it is, the change is only made in the database metadata.

Edit: I would strongly...

raviraikulkarni (12/5/2008)

---

if one of the transaction log backup file in the

sequence is not available available the how to

restore to point in time

for eg. i have transactional...

I ran your second...

Table definitions please, index definitions and the execution plan, saved as a .sqlplan file, zipped and attached to your post.

Oksana March (12/5/2008)

---

They're used waay too much by people who think they're a great solution and they perform terribly. SQL...

To do what?

Why do you need to add columns to a table inside a stored procedure?

What's BES Replication?

I've got, on my desktop, a replication...

Agreed. This is almost a textbook case for transactional replication

It looks like it needs an existing DB selecting, but you can type a new DB name into that box

No. As I said above

Replication does not require any particular recovery...