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

Explain logical operators in sql server?

0 Answers  

Diffrent types of function

1 Answers   Wipro,

What is data source document?

0 Answers  

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

Tell me can we use custom code in ssrs?

0 Answers  

What is the purpose of update statistics and scope_identity() function?

0 Answers  

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

What is data compression?

0 Answers  

What are relationships and mention different types of relationships in the dbms

0 Answers  

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,