Thank you Gian, very good point really.

Thank you Steve

bitbucket-25253 (6/26/2011)

---

The scenario is not mine, but rather one from Paul Randal's blog, so it...

Great question Ron. You provided an excellent scenario to understand a concept. Thank you.

It is a straight forward answer, but I am surprised more than 40% got it wrong.

I was checking below link related to moving tables from one filegroup to another.

http://stackoverflow.com/questions/2438019/how-i-can-move-table-to-another-filegroup

The explanation is fine. However, at the end of the link, there is below statement.

Yep. And...

Good question. I got to know something.

GilaMonster (6/21/2011)

---

Files cannot be moved between filegroups. End of story.

You can use Shrinkfile with the EmptyFile option to empty the file so that it can be dropped, but that's it....

Thank you for letting us know

Thank you Krishna

azhar.iqbal499 (6/20/2011)

---

I am facing same sort of problem. Please tell me where to start Distribution agent. I am not able to find exact screen at the distributor from where I...

I came across some useful links. One of them says this could occur " if the Distribution Agent or Merge Agent is started before the Snapshot Agent has finished generating...

winash (6/20/2011)

---

You can use Adam Machanic's sp_whoisactive script to detect blocking (this can be downloaded from here). Use this to check for activity on the server and dig deeper into...

I hope you are going to SQL Server books online and typing the link in URL link as you can't get this link by typing in google.

Can you tell what...

Try this for removing the replication related objects.

sp_removedbreplication

Here is the books online link for more details:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10rp_5techref/html/cb98d571-d1eb-467b-91f7-a6e091009672.htm