That's a large number of rows - this could cause performance issues reading commands to be...

How many rows are there in your msrepl_commands table on the distribution server (do a SELECT sum(rows) FROM sys.partitions WHERE object_id = OBJECT_ID('msrepl_commands') AND index_id IN (1,0) - if your...

1.How do i restore db back to a specific time frame from dbsnapshot?

(For example i have taken a DBSnapshot @ 8:00 ,second

@8:15 ,third @8:30)..How will...

The way to do this using xp_cmdhsell is as follows:

EXEC master.dbo.xp_cmdshell 'sqlcmd -S ServerNameComesHere -E -d ToolDB -Q "EXEC dbo.InsertTempValue 101" ';

Could you let us know why you are using...

Actually thats what we have been doing. My biggest concern here is whenever we add a new object to subscriber we need to reset-up replication and re-create all synonyms (...

Nested INSERT...EXEC statements are not supported (this is a feature that will not be supported as per connect -> https://connect.microsoft.com/SQLServer/feedback/details/272133/cannot-have-nested-insert-exec )

Check http://www.sommarskog.se/share_data.html#INSERTEXEC for a more detailed description on the issues...

Not sure if this is what you are looking for - did you check the System_Title column in the DimWorkItem table?

http://blogs.msdn.com/b/nericson/archive/2010/03/08/tfs-2010-method-to-get-work-items-as-of-a-date.aspx

Some articles that might help you:

http://blogs.msdn.com/b/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx

http://blogs.msdn.com/b/repltalk/archive/2010/02/03/high-level-transactional-replication-process-flow.aspx

Setting up verbose logging -> http://blogs.msdn.com/b/chrissk/archive/2010/01/05/walk-through-of-kb-article-312292-how-to-enable-replication-agents-for-logging-to-output-files-in-sql-server.aspx

Maybe using the MOVE clause of ALTER TABLE might help? I haven't tested this out - but I've used this to move a table onto a partition scheme and maybe...

Agree on output clause being the best option 2K5 onwards - but it looks like the OP is looking to get this value from a remote server in which case:

-...

From BOL:

The scope of the @@IDENTITY function is current session on the local server on which it is executed. This function cannot be applied to remote or linked servers. To...

If you want to check what is the configured value in your replication setup: sp_helpdistributor_properties

If you want to modify this value -> sp_changedistributor_property

How do you re-initialize? Snapshot or from backup?

If you initialize from backup you'll need to re-create the triggers everytime (since your audit tables are in another DB they'll not be...

Could you elaborate on what you mean? Do you mean storing UTF-8 or UTF-16 data in the DB?

These links might help:

http://blogs.msdn.com/b/qingsongyao/archive/2009/04/10/sql-server-and-utf-8-encoding-1-true-or-false.aspx

From this article:

When you choose nvarchar as your data type,...

You will have a performance impact. This is explained well here (including details on how...