Do you get any more information if you use the Login Failures trace template in Profiler?

The main thing that should give you is the process ID on the App...

Thanks for your help - It makes sense now

Cheers,

Bodsda

Thanks for that, it worked. But why didn't my cursor work?

Thanks,

Bodsda

Hmm, yeah that's what I'm currently doing. Would have been nice to use policies though.

I get the feeling that the policies are some bodge add-on that got hacked into the...

After running some tests in python, I don't think the two operators are the same. This is definately not conclusive proof but does show a difference in execution speed.

>>> import...

But what if the size of the data is bigger than the initial size?

A problem I have had when configuring DBMail is not setting a default mail profile in the SQL Server Agent(> Properties > Alert System > Enable Mail Profile)

Bodsda

Unfortunately, I have no control at all over the queries on this server. All of the databases are from third party providers that we have a managed service with, so...

Here is a link to an excellent blog post about permissions

http://consultingblogs.emc.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions--_2800_2_2900_.aspx

Bodsda

GilaMonster (1/19/2011)

---

The corruption you have is not repairable.

You have two options.

1) Restore from your last clean backup

2) Script all objects, export what data you can (some will almost certainly fail)...

GilaMonster (1/19/2011)

---

I'm going to see the whole lot. Though, from the part you posted, it doesn't look like it's repairable.

To get the entire output, open a command window (Start-> Run->...

Output attached.

I took over...

Henrico Bekker (1/13/2011)

---

The average usage of RAM by both instances is about 20GB for instanceA and about 10GB for instanceB, but both instances have at some point taken > 30GB...

Excellent, thanks for that.

I went on to write this. Let me know what you think. It's my first adventure into T-SQL

create trigger DB_CREATION

on ALL SERVER

for CREATE_DATABASE

as

declare @data...