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

Taking one step back... Why do you need to add columns to a table in a stored procedure?

Did the installation of the patch give any errors?

I think you may want to take this issue to Microsoft's customer support. They're probably going to be able to help you...

Replication does not require any particular recovery model. All forms of replication (snapshot, transactional, merge) work fine...

Consider transactional replication rather.

Mirroring is a high-availability solution, not for reporting.

Call another procedure.