How To Know SQL Server Service Pack In Your Machine

How To Know SQL Server Service Pack In Your Machine Hi Guys in this tutorial i will explain you How To Know SQL Server Service Pack In Your Machine.If you’re running SQL Server, it’s wise to keep latest service pack installed for optimum performance. If you’re not sure about service pack (or if you’re still running

How To create a Publication In Replication

How To create a Publication In Replication When creating a publication, you choose the tables and other database objects that you want to publish. You can publish the following database objects using replication.When publishing a table for replication, you can specify which schema objects should be copied to the Subscriber, such as declared referential integrity

What Is Replication And Its Types

What Is Replication And Its Types Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks. Why

How to Export Excel data in SQL Server table

How to Export Excel data in SQL Server table Many Sql server guys deal with this How to Export Excel data in SQL Server table.Many DBA following the same approach they export data from flat file or other type of file to SQL server tables.Here we have a quick view on how to export data from excel

How To Import Data From SQL Server To Excel

How To Import Data From SQL Server To Excel In this tutorial i will let you now that How To Import Data From SQL Server To Excel, importing data from SQL Server to Excel is not a difficult task but it may be if you don’t know about it. Importing process will import your whole