Drop and Restore DB - Your last backup before the reboot should bring the DB up without the "delete transaction" (as it wasn't completed).

Poor engine handling of SQL code (Recursive CTE's).

Someone turned page level locking of on an index.

Someone used explorer to open a folder on the machine where a corrupt file exists.

Someone...

Glad to be of assistance:-D

That's what's known in the business as a "Scream Test"

homebrew01 (12/2/2009)

---

Eoin (12/2/2009)

---

I see a SPN error message in the posted sql logs, have you recently changed the permissions of the service accounts (or changed the accounts).

Also is the E...

homebrew01 (12/1/2009)

---

I've rebooted several times, and the drives have been available. Not sure about drive availability when the problem first appeared.

The errors in post #4 came from the event log.

If...

Jeff Moden (12/1/2009)

---

I agree with GSquared. The newly "INSERTed" row is in the original table. All you're doing with capturing INSERTs is effectively doubling the data. With...

rhunt (10/12/2009)

---

Just following back up. I had let the server go for a while because service wasn't really being impacted in the environment and I was trying to get...

rhunt (10/8/2009)

---

There...

Try running the following

select name, SUM(single_pages_kb + multi_pages_kb)/1024.0 MBUsed

from sys.dm_os_memory_clerks

group by name

order by 2 desc

with particular empasis on figures for Tokenandpermuserstore, sql plans and object plans

Simple Formula: 32 Bit OS

If your system has 4 GB and 16 GB - use /PAE + AWE

Check out this link

http://blogs.technet.com/vipulshah/archive/2007/05/10/3gb-pae-and-awe-on-32-bit-systems.aspx

I've also noted that SQL has exceeded the max settings on a numebr of our severs. See below from kb321363

Note that the max server memory option only limits the size...

Login Errors

Since beginning to use WA we have had the following errors

1. Cannot generate SSPI context. (.Net SqlClient Data Provider)

2. Login Failed for user '', the user is...

Thanks Gail,

I am giving the developers the option (initially) to view all definitions for all users in a specific role

i.e

use my_db

create role dbreader

Go

sp_addrolemember 'db_datareader','dbreader'

Go

GRANT VIEW Definition TO dbreader --Will...

As regards giving the users the ability to view definitions

I found this info here http://www.mssqltips.com/tip.asp?tip=1593

So USE [dbname]

GO

GRANT VIEW Definition TO [reader_role]

Will allow a members of a role...