FOR /F : As we discussed earlier post it used same to traverse rows from generated file from SQLCMD command. Here we do not have values with delims (,) and we have only one values to grab and assign in variables. forfiles.exe : It is used to delete f...

Security is the main thing for servers and sql servers and we need to trace it for security management. Have to need track who are using it, what they are doing and when they performed. For SQL Server 2005 and later versions we have some DDL events whic...

...

Before so many posts published I posted for the old database backup files archive using TSQL and using SSIS.  Hope you visited that post and you liked them. I am repeating the same thing here but it will be with two different methods, first one wit...

Following is the script to add stored procedures in publication using tsql script for transactional replication. It is just same as adding views in publication , You just need to change relevant objects and type in script. [CODE] USE PublisherDB G...

Same as stored procedures & views adding in publication, we can add functions in publication for transactional replication with following script where you need to change type and add function name as a article. [CODE] USE PublisherDB GO exec sp_...

I have shared a script to enable replication database http://beyondrelational.com/justlearned/posts/724/enabling-the-replication-database-in-sql-server.aspx, here you can find a script to create publication after enabling the replication database. You c...

I have shared queries to find out objects which are published in replication 1. Objects having data and schema replicated (Tables), http://beyondrelational.com/justlearned/posts/639/sql-server-how-to-know-the-objects-published-in-replication.aspx ...

You may read earlier post to add transactional publication in replication here http://beyondrelational.com/justlearned/posts/730/adding-the-transactional-publication-in-replication-sql-server.aspx, here how can we add a transactional pull subscriptions ...

As last time i submitted script to add table in existing publication here http://beyondrelational.com/justlearned/posts/692/script-to-add-table-in-existing-publication-in-replication-sql-server.aspx, you can find the script to add views in existing pub...