It is possible to easily list the replicated databases:

select * from sys.databases

where is_published = 1

Note that, if you try to store all the insert/delete/update info for all the tables in the db, it can...

Where do you see this error message?

Can you post the complete...

COPY_ONLY does not break the log chain.

So if you have log shipping configured, you can use COPY_ONLY option to take a full database backup of testing, etc.

azhar.iqbal499 (12/1/2011)

---

I have implemented TDE at Database. I want to test the TDE. What is the procedure of this. Should I create new user for this or should I take...

Check the create_date in the sys.views.

If it is newer than the date the view was deployed, it means the view was DROPped and reCREATEd.

Your...

You have to consider permissions also. Grant minimum permission to the users.

By revokeing ALTER permission, you can...

1) Enable TCP/IP protocol

2) Enable Remote Connections

Try this:

select * from sys.databases where is_distributor = 1

sp_helpdistributiondb

sp_helpdistributor

Since you are not using the default port

1) Mention the port number with the servername (or IP) or

2) Make sure that SQL Server browser service is running on the server.

Also run:

xp_fixeddrives

and post the result.

cjohn5552 (11/29/2011)

---

Thanks for the replies. Yeah, I'm running a restore query that a colleague wrote, so I may not understand it very well. The .bak db file was on the...

I don't think select on a table blocks update on a different table.

How did you notice this or come to this conclusion.

delete from a

from EMP a

inner join (select [EMP_ID],MAX([DEPT_ID]) DEPT_ID From EMP group by [EMP_ID]) b

on a.EMP_ID = b.EMP_ID

and a.DEPT_ID < b.DEPT_ID