In SQL 2008 SSMS Object explorer details tab sort the objects by row count.

Is it SQL 2000 to 2000? or other version? Did you check the collation is same on both publisher and subscriber database?

It won't be a problem, only thing while applying SP's make sure you select right SQL server version for applying hotfix's otherwise it will fail. I would recommend to keep...

I don't think if you change server name it will cause any issue, Only thing is you should script the linked server connections and change the server name (named instance...

OK, I recall now.

It was because I was under the impression that merge had a higher latency between updates.

So that instead of being "near real time" it was defered until...

Adding to Mani's questions....

If backup is failing on only one database, run checkDB on that database. Get in touch with server team and see if disk went offline at that...

So:

1. How can I determine when a change has propigated

--Is there some nifty tool to show nice pretty graphs of how fast replication is happening, etc...

2. Conflict...

ppreston (3/3/2010)

---

I am currently running my reporting services on a seperate box from my SQL Server and now I'm asked to move it to a virtual server. So does anyone...

chrisph (3/10/2010)

---

Is it necessary for me to copy over the .mdf and .ldf files from the source server to the destination server?

I cannot point to the original .mdf and .ldf...

How could collation of databases is different from Server collation? unless some one mentioned collation for database explicitly while creating new database.

Check this it will aswer your question.

http://msdn.microsoft.com/en-us/library/ms184286.aspx

Need more info Check what SPID is blocking, and see which query, see why it is taking lock on the objects.

Steve Jones - Editor (3/10/2010)

---

OK, OK, some funny replies in here. The question was badly worded but let's not scare someone away from posting. I'm sure there is a valid...

Can you check SQL error logs and see any TCP\IP related error messages and post here?

kwilt (3/10/2010)

---

I know what is causing the file to grow; and there are still open transactions as the process is still running. If I ask the user to terminate...