Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 15

Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value is (55822684521).

The statement has been...

As Bhunesh mentioned that users will have system admin rights.

if you want a particular login to have full access on particular db give that user\login db_owner rights.

Thanks Gail & OPC

Hi Faizal,

This is production box

Thanks Anthony,

Any solution?? Anyway to find what this causes??

Thanks Satish for the reply.

I have already gone through that and wont help in this situation.

We have SQL Server 2005 SP4

Bhuvnesh (1/21/2013)

---

Tara-1044200 (1/17/2013)

---

3. If 1st file is filled does it uses the second file and so on untill it max out to 1TB or 10 files any query would...

Perry Whittle (1/17/2013)

---

That's the order i prefer to do it in. Set the paths and confirm that sql server has updated the system catalogs, you will receive a meesage indicating...

Thanks Suresh,

Drives are almost same.

The thing is we need to stop the services for moving files right?

Thanks Perry,

So first we have to run the ALTER database MODIFY FILE and then only we have to take database offline right?

Thanks Gail,

i used the command

ALTER DATABASE ABC MODIFY FILE ( NAME = ABC_log FILENAME = 'H:\Log\SQL8\ABC_log' )

Thanks Gail and Perry.

What i have to do now?? I followed http://msdn.microsoft.com/en-us/library/ms345483(v=sql.105).aspx this article which caused all this issues.. How can i move the .ldf file now to another drive??

Are you talking about index fragmentation??

If yes it happens only if you shrink data file or the whole DB

george sibbald (1/16/2013)

---

Ratheesh.K.Nair (1/15/2013)

---

Dev team have created queries to remove duplicate records from DB and it is removing this many records per year starting from 2009. Is it good or...

Thanks SQL Show & George