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

How to create a dynamic cursor with the dynamic option?

0 Answers  

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

Difference between Function and Procedure-in general?

6 Answers  

What is the difference between primary key and unique constraints?

0 Answers  

What triggers long term care?

0 Answers  

What are the differences between char and nchar in ms sql server?

0 Answers  

How adventureworkslt tables are related?

0 Answers  

Is there any difference between the primary key and unique key?

0 Answers  

What is the definition for sql server 2000?

0 Answers  

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

What is a data source or ds? : sql server analysis services, ssas

0 Answers  

What is the recommended total size of your memory optimized tables?

0 Answers