I have a function where I call "sp_who2" and take database and username as parameters to the function.

Works great.

It CAN be done if you use OPENROWSET with a loopback linked server.

If you should is another question.

Two for the price of one

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115751

Consider this

DECLARE@Sample TABLE

(

id INT,

type VARCHAR(20),

name VARCHAR(20),

parent_id INT

)

INSERT@Sample

SELECT 0, 'root', 'root', nullUNION ALL

SELECT 1, 'account', 'Fred Jones', 10 UNION ALL

SELECT 2, 'account', 'Lisa...

Which is easier than STUFF(REPLACE(STR(Col1, 4), ' ', '0'), 3, 0, ':')

I still can't see the reference to use only half the maximum number of processórs.

You can also add the WITH NOWAIT to the RAISERROR statement.

What about setting the cost threshold for parallellism at server level?

Where is the reference to your suggestions?

If times are AM, use

STUFF(REPLACE(STR(Col1, 4), ' ', '0'), 3, 0, ':')

Same question asked and answered here

http://www.sqlservercentral.com/Forums/Topic610093-145-1.aspx

Try this trigger

CREATE TRIGGER dbo.trgZeroUnique ON dbo.Table1

AFTERINSERT,

UPDATE

AS

IF EXISTS (SELECT eMail FROM Table1 GROUP BY eMail HAVING COUNT(*) > 1 AND MIN(ID) > 0)

BEGIN

ROLLBACK TRANSACTION

RAISERROR('Duplicate eMail found.', 16, 1)

END

My $0.02 input.

I think OP is one join from solving the unified field theory. The query is 19852 characters.

The query returns 290 columns and joins 62 tables. Under these cirumstances...

Or use the DATABASEPROPERTY function like this

SELECTDATABASEPROPERTY('master', 'IsInRecovery')

http://weblogs.sqlteam.com/peterl/archive/2008/05/13/Lightning-fast-collapsed-date-ranges-and-missing-date-ranges.aspx

See my article here about how to work with DATEDIFF function

Datediff function demystified