what is DTS what are tasks available
Answer / seshagiri
DTS is set of graphical tools and programmable objects,
using that we can extract,transform, and consolidate data
from source in to multiple destinations.
Tasks are....
Transform Data
Copy and Manage Data
Function as Jobs
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you delete a trigger?
Benefits of Stored Procedures?
What is wide table?
what are cursors? : Sql server database administration
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What are the different types of replication are there in sql server 2000?
Can you explain full-text query in sql server?
What are clustered and non-clustered index?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
What kind of problems occurs if we do not implement proper locking strategy?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
How do I get to sql server configuration manager?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)