Yes, I realise that. Your grid has Create/alter login listed twice, sysadmin is checked on...

He's at SQLConnections at the moment so probably rather busy, but I...

Your grid indicates that sysadmin cannot create or alter logins. That is incorrect.

If you don't have an existing SQL trace, there's no way to tell who did this. The SQL log should have an entry saying that it happened, but not who...

Is the SQL Service running? That's 2005's generic 'can't connect' error.

Can you post the query, the table definitions and any indexes on them?

A view has to be a single select statement, so no EXEC in it . Why does it...

I'm not sure why that's not repairing. I'm sure Paul will drop by soon and explain in detail.

In the meantime...

You say you don't mind losing data. If that's the case,...

You don't really have many options.

If you have a clean backup and all the log backups since then, you can restore. There will be downtime though.

You can take the DB...

What events are you tracing, what filters...

yulichka (3/22/2009)

---

It says that in order to run dbcc repair that my db needs to be in single mode,but my db in multi user mode, if I switch our web...

JamesNZ (3/22/2009)

---

Mark it as reusable or clean the space completely? A log file for a db didn't shrink down to 0KB, and stayed at 3.2GB, any idea on why that...

Can you post the full output of the following command please. I'd like to get a full picture of what's wrong before recommending anything.

DBCC CHECKDB (< Database Name > )...

On SQL 2000, unless you were running a SQL Trace already, there's no way to tell who did it or when.

Before you run it (though looking at all your other posts, it may be a little late) note that REPAIR_ALLOW_DATA_LOSS should be a last resort for fixing corruption. As it's...

Since all of the CheckDB repairs require that the DB be in single user mode, there cannot be any blocking.

yulichka: See my comments...