Answer Posted / 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.

How do you debug a procedure in sql server?

992

---

Explain about SQLOS?

1054

---

Explain ranking functions?

1094

---

How do I create a stored procedure in sql server?

1092

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2006

---

Give an example of why you would want to denormalize a database

1028

---

What are the different types of upgrades that can be performed in sql server?

1212

---

What is an indexed view?

1005

---

If a table does not have a unique index, can a cursor be opened on it?

957

---

What happens if date-only values are provided as date and time literals?

1073

---

What happens if you add a new index to large table?

979

---

What are the requirements for sql server 2016?

929

---

What is entity data services?

1107

---

In how many ways you can invoke ssrs reports?

147

---

Do you know the different ddl commands in sql?

1097

---