You can shrink the logfile. You can do that by issuing the following command

dbcc shrinkfile ('LogFileName',8000)

This would shrink your Log File to 8 GB. You can find more information about...

I agree with Sean. Table Variable approach is simpler.

I dont think so. What you can probably do is a pass in the field that you want to order by as a parameter to the sp and use that...

Not sure what you mean by Optimizing Transaction Log but here is an example of how to take Transaction Log backup of database AdventureWorks2008R2 to C Drive

BACKUP LOG AdventureWorks2008R2

TO DISK...

What do you mean by transaction logging througput ? Did you mean how to backup transaction log ?

Thanks for the suggestion. I will explore this option.

Reddy

If you are interested in how our topology is setup here are the details.

Server A - USA

Server B - China

Laptop C - China

Latop D - China

A and B...

If you want to do automate the process of scripting all objects in a database consider SQL Server Database Publishing Wizard. You can execute this program from command line

Database Publishing...

We had a similar situation in our environment. There were a lot if spids getting blocked and CPU was around 95% all the time. A lot of these queries were...

Did you try Replication Monitor. It gives more information about the objects being synchronized.

I will look around and see if there is a stored procedure that results synchronization status....

I doubt if there is a relationship between backupset table and jobs table. You can take a backup without a job and this would still make an entry in backupset...

Nice question. Thanks

Thanks for the question..

Thanks for the fix buddy. It saved me a lot of time.

I need to get this client to move to SSRS 2008R2.

Thanks again,

Reddy

That works. Thanks for you help Eralper.

Following is a good link on how to load xml into sql server.

http://weblogs.sqlteam.com/peterl/archive/2008/09/01/Updated-XML-search-test-case-with-variables.aspx

Reddy