Answer / hari

first you rebuild the master db by using REBUIDM.exe. after
u take single user mode Sqlservr.exe -c -m.

What do I need to start working with sql studio? : sql server management studio

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

What is indexing and its types?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

What is difference between drop truncate and delete?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---