How can we move data along with schema of the server object?

- We can copy data along schema using DTS package.
- DTS provides a set of graphical tools and programmable objects to help administrators and developers to solve data movement problems.
- These DTS packages runs periodically when certain events are occur.
- These packages can be used to create DTS solutions.

Define sub-query

Sub-query is a query within a Query........

sp_grantlogin, sp_denylogin and sp_revokelogin

All these three are the system stored procedure used to manage windows account authentication........

Write SQL query to retrieve all tables of the database

Select name from sysObjects where xtype=’u’.......

Post your comment

CareerRide on YOUTUBE
CareerRide on INSTAGRAM

How can we move data along with schema of the server object?

How can we move data along with schema of the server object?

Related Content

Follow us