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

Is there any difference between primary key and unique with the not null condition?

0 Answers  

Write down the syntax and an example for create, rename and delete index?

0 Answers  

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

Explain try...catch with sql server?

0 Answers  

How does normalization work?

0 Answers  

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

What are unicode character string data types in ms sql server?

0 Answers  

what is sql server? : Sql server database administration

0 Answers  

Explain comment on transactions?

0 Answers  

Write an sql query to find first weekday of the month?

0 Answers  

What is the full meaning of dml?

0 Answers  

What is self contained scalar sub query?

0 Answers