Answer / bhushan

Use BCP command in SQL server.

Answer / harish sharma

Sysdatabase table is the part of master database.

So u need to change the location of master database in this
case. which can be don in the database properties ->
statring parameters. Then u have to change the location of
all three files. master.mdf, master.ldf, and error file.
Then after stoping SQL agent you can move files.

Answer / jijo

Take the full backup of sysdatabse and specify backup
location into d:\

Answer / amr

1st u have to stop sqlserver then u can catch file and copy
it anywhere !!

Answer / anwar hayat

Stop MS SQLServer Services and copy mdf ldf files in desire
location.

Answer / samar

plz explain in brief,

if u can send me screen shots for process , it ll be good
for undetstandin
mail id: summer_sinha@yahoo.com

What do you understand by triggers?

0 Answers  

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

What is normalization of database? What are its benefits?

0 Answers  

Explain the difference between HTTP and HTTPS in database?

0 Answers   Wipro,

What is tempdb in sql server?

0 Answers  

Explain different types of index?

0 Answers  

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

What is similarity and difference between truncate and delete in sql?

0 Answers  

Will count(column) include columns with null values in its count?

0 Answers  

what is datawarehouse?

0 Answers   Informatica,

What is intellisense?

0 Answers