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

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

1 Answers   ABC, TCS,

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

How to turn on the mssql api module in php?

1 Answers  

What is database replication? What are the different types of replication you can set up in sql server?

1 Answers  

How to copy the tables, schema and views from one sql server to another?

1 Answers  

Explain the advantages of merge replication?

1 Answers  

What is field in algebra?

1 Answers  

How to link tables in sql server?

1 Answers  

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,