Did you have a look at the DMV I told you? It's all...

A SPID -3 is realted to a rollback and should resolve after a while automatically.

See also http://social.msdn.microsoft.com/Forums/eu/sqldatabaseengine/thread/e1fe4044-1c25-4c6d-9aa5-7828ec4e2451

WHY??? SSIS is just the tool designed for this kind...

The short answer would be YES, it is possible. All the necessary information can be queried from various DMV's like sys.dm_os_sys_memory, sys.dm_os_sys_info, sys.dm_os_performance_counters or sys.dm_os_ring_buffers.

I don't have a nice ready-to-use...

Jeff could you send us a download link for it?

Actually there are quite a lot of free tools around, you only have to know how find them and determine what exactly are your needs. Codeplex is always a good...

MysteryJimbo (3/8/2012)

---

The SQL server transaction and error logs are not editable. They can be "read" in a fashion but not in an easily readable form.

Worth noting that successful logins...

What do you mean by SQL Server Security Log ? And why do you...

In sys.indexes you will find the column "allow_page_locks".

But why do you post this question in a 3 year old thread instead of creating a new one?

In order to view reports a user have "System User" permissions on the site level and be a member of the "browser" role either for a specific report or on...

stebennettsjb (3/6/2012)

---

Hi MarkusB,

But wouldn't that create a temp table on every server, with the results of only the server its created on. I would like to run a query...

What exactly is your problem?...

There are a couple of options how you can do this and the best choice will probably depend on what exactly you try to achieve.

With SQL 2008 you have the...

If it is your intention to just let him see the definition of procedures en functions you could GRANT SELECT permissions on sys.sql_modules or maybe even better create a view...

balasach82 (2/28/2012)

---

1. For Extended SP's, I go to Database Properties->Security-->

Roles-->Database Roles--> Public--> Properties-->Securables

Here, I see a number of Extended SP's. I had to select each one and then remove EXECUTE...