I think there are many good reasons for connecting things to the internet, and to let them be computer controlled.

Not to ruin your wind shield story - but I...

Hi all

I am sorry to leave this post open.

I have resigned from my current job, and never got back to solving this problem due to reprioritisation.

Thanks for using your...

Ok.

I will go back and verify the rights of the users.

What would be the most correct way to figure out who has the connect right?

I would do...

The SQL login user e.g., does belong to a role, but nothing but dbo has CONNECT right to the database.

Has tested a little further, and found that the user...

I will try to generate a more complete post, but have ran into another task that i need to look at now.

I will get back with a more thorough explanation,...

Well sorry for not posting the execution plan, or explaining properly.

But you are exactly right.

I have an index covering bTable AssetId, AssetSiteId, VersionId and VersionSiteID and with the appropiate...

I see you point now....

Here is another one, which i would actually rather like you to see on. The first one may be caused by some manual run procedures...

Ok, will do that.

I just exported from the log viewer.

I'll look forward to hear from you when you've had the time to look at it.

Do you want me to...

Ok, here it comes:

I have replaced database name, machine names, table and procedure names, but that shouldn't impact on the essence.

I hope this gives meaning to you. 🙂

Date,Source,Severity,Message

01/09/2009 10:55:12,spid15s,Unknown,waiter...

Hi all,

Now i actually caught a deadlock - they don't occur very often any more since i have made a change in a specific trigger, where they did occur most.

How...

Thanks. We learn every day... 🙂

Hopefully i get some results on this side of Christmas, but going on holiday tomorrow, so propably i won't post any results this year.. 😉

/Anders

Hi

I have now experienced a few deadlocks catched by my own logging mechanism since i turned on trace 1222. I did that with

DBCC TRACEON(1222)

But i can't find anything in...

Hi

By tasks i didn't mean anything process-like. A task is just an object in our domain model. It could just as well had been a car, with a property cabin...