Welsh Corgi (1/2/2012)

---

george sibbald (1/2/2012)

---

The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe...

GilaMonster (1/2/2012)

---

Feeling...

First of all good luck.

you don't say where in the UK you are but if you are in the right geographical location the jobs are out there, and there are...

The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe us?

🙁

You get that error because the previous owner is now an invalid login. That being the case the login was obviously not essential to the operation of the database, so...

thanks for the 0x007 points steve - happy new year. 🙂

GilaMonster (12/31/2011)

---

With...

you only need to run dbcc checkdb on a regular basis, as all the other check commands are a subset of this one command (checkalloc, checktable etc).

so this one command...

GilaMonster (12/30/2011)

---

george sibbald (12/30/2011)

---

chetanr.jain (12/30/2011)

---

Adding to Gila's Comment :

In simple recovery model, Log will be cleared once the checkpoint is fired or Free space falls below 10-30% of the total...

chetanr.jain (12/30/2011)

---

Adding to Gila's Comment :

In simple recovery model, Log will be cleared once the checkpoint is fired or Free space falls below 10-30% of the total space ( depends...

shappy noo year. Hic!

:blink:

yep, if he has admin rights on the server

what do you mean already existing? Do you have a perpetually running server side trace?

I would stop the current trace and restart it with the changed parameter.

the @maxfilesize (4th) parameter in Stored proc sp_trace_create

despite your request not to post here seems more apt to -

are you locked out as admins have no rights to SQL? Try starting SQL in single user mode, connecting...