how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.

Answer Posted / bhushan

Use BCP command in SQL server.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of normalization?

824


What is the difference between implicit and explicit transaction?

745


How to populate a table in sql server?

668


Which joins are sql server default?

690


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

712


What does top operator do?

756


How does stuff differ from the replace function?

747


What are the 3 types of schema?

793


What is recompile sql server?

772


Is it possible to call a stored procedure within a stored procedure?

742


Why use “nolock” in sql server?

734


Can the “if update (colname)” statement be used in a delete trigger?

759


How to replace the Query Result 'Null Value' with a text ?

775


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1926


Do you know what is lock escalation?

780