Thanks! This is fixed, something I overlooked on my part.

I fixed it by dropping the indexes on the table and recreating it.

While recreating unique index I got error and found out that here were 28 rows that...

I noticed that SQL SERVER was running under NTSERVICE\MSSQLserver account. I changed that to run under domain service account and this resolved the issue Thank you!

Adi Cohn-120898 (8/5/2015)

---

I would try running the command

exec sp_readerrorlog

In case that the bug is because of the GUI, it should work. If there is another problem, then you'll...

The issue is resolved. Changed the SQL SEVER agent user to a new service account and it started to work.

The services was using the built in account tried to change is to the service account through the services properties window but getting an Access denied error now.

GilaMonster (7/17/2015)

---

You don't have enough space in the log for the ALTER. It's a single transaction, so recovery model doesn't apply (and please make sure you fix the broken log...

Never mind it is in CHECKPOINT state now. It was a concern because the queries were running very slow.

I ran the command in all the hundred...

dbcc opentran('tempdb')

No active open transactions.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

GilaMonster (6/25/2015)

---

It'll be 2TB, not 2GB and that's the max size that a transaction log file can reach, so it's the same as unlimited.

btw, the error was telling you the...

client01 5720 0 500

client01_log 2097152 2724 100

Scott Coleman (4/2/2015)

---

Your package must use some 32-bit component or driver. Try identify it and find a workaround.

If no workaround can be found, force it to run as 32-bit....

lebraix (4/2/2015)

---

Try going (in VS) to Project -> <Your Proj Name> Properties -> Configuration Properties ->Debugger -> Debug Options -> Turn off 64 bit runtime (set to false) and see...

John Mitchell-245523 (3/27/2015)

---

Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected...