This happens when the database was participating in transactional replication but it was removed properly or restored from a replicated database.

To stop this, add the database to replication and...

Is TCP/IP enabled under SQL Server Network Configuration for the SQLEXPRESS instance?

Note that after enabling the protocol, the service needs to be restarted.

Enable TCP/IP protocol using SQL Server Configuration Manager.

I think, no need to re-install.

Try "... or add features to an existing installation" under Installation in SQL Server Installation Center.

BTW Replication is not a service.

Hope this helps you.

Are you thinking that EXEC %% is a different command? It's not. It's the same EXEC.

What is different is %%xxx. These are undocumented and meant for internal use by Microsoft.

Nothing happens, I guess. Because policies are stored in MSDB database. Not in other databases.

What are your expectations and concerns?

Hi Ali,

Positive thinking is very important.

Update your resume and upload it to http://www.naukri.com

Wish you good...

In SSMS, expand SQL Server Agent, right click on Proxies and select New Proxy...

Before creating...

Run dbcc loginfo()

Notice the FileId and Status columns. Status 2 means active.

For example:

FileId ...

What/Where is the option (to replicate indexes)?

Please elaborate your reply.

Check the Replication Monitor for the reason for the latency. You can also check the log-reader and distribution agent job history.

Transaction log size should not be cause of concern.

Thanks HowardW

Yogirk (9/2/2010)

---

What I would like to know is - Is there any way to find whether *anything* changed in the database since the last tran log backup - looking...

Since you have enterprise edition on the production server, my suggestion is to install same (=Developer) edition on staging and development servers too.

It looks like system background process was performing Auto-shrink, which did not allow you to have exclusive access to the database to restore.

Disable Auto-shrink and try to restore.