Hi Robert!

You are welcome.

I haven't seen that problem so far. Have you reutilized the "-SqlInstance" parameter after your clean up? Or did you start one session from scratch? If the...

Hey Ken,

Wishing you a speedy recovery!

I'm glad you found it useful Peter. Even if you are not using it right now or using your own solution. 🙂

On the permissions field, I also encourage people to...

Hi Low Rider,

See if this helps (http://msdn.microsoft.com/en-us/library/ms176013(v=sql.105).aspx):

SELECT TOP 10 login_name, SUM(cpu_time)

FROM sys.dm_exec_sessions

WHERE session_id > 50

GROUP BY login_name

ORDER BY SUM(cpu_time) DESC

Basically will give you the logins with most...

anarayanamoorthy

try this: http://www.eggheadcafe.com/software/aspnet/34150451/enable-the-sa-account-or-set-back-sysadmin-permission-an-account.aspx

The other day there was a programmer who had the SA account inactive and did not know the password.

I followed these instructions and managed to activate...

Question answered!

At server's permissions scope I have an DENY VIEW DEFINITIONS!

As is normal within the database will not have permissions to view the metadata of the system SP!

But if users...

More or less! 😀

I allready have my question's answer!

If inside the database I put the users associated with db_owner Role they stayed with the same permissions as "original" db_owner!

This...

Are you talking about performance counters?

If yes, yes I have had monitorizing using some SQL counters like RowLocks and PageLocks.

There is a few RowLocks but...

GilaMonster (6/24/2010)

---

Cláudio Silva (6/24/2010)

---

This sp in non-concurrencial (one/two requests per second) environment takes between 0 and 50ms which is great, but when enter in concorrencial environment (dozens of requests in...

Thread title says "without" 🙂

Read my previous post I think now it's more clear

GilaMonster (6/24/2010)

---

Cláudio Silva (6/24/2010)

---

I have a problem caused by one SP that is executed simultaneosly dozens of times in the same milisecond and duration takes between 600 and 800ms most...

Gianluca Sartori (6/24/2010)

---

Deadlocks occur when two (or more) concurrent sessions hold locks on the same object (table, row etc.).

Typical scenario is something like this:

Session 1 ...

Another doubt is..all credentials must be an Windows Account??

Can be an SQL Login?

Yes, the solution was create an 3rd parameter on the 1st SP which says if return an XML or an Table..after this I do an

INSERT...

Florian Reischl (9/7/2009)

---

A third parameter gives you the possibility to use both ways from everywhere. If you call your...