You should add the PARTITION BY clause. Since I cannot run your code, I'll show you how to do that with a query that will also run on your...

Hi

What is your function doing with such a long text?

There are some ways to get a round this limit, but usually you do not want to process such long texts.

Post...

Hi

You could try

EXEC sp_who2

But if you want to get the counts, try this:

select db_name(dbid),count(*) NumOfConns from master..sysprocesses group by dbid

Hope this is what you were looking for

Tal Ben Yosef

http://www.scepia.com

I'm afraid the compiler is right...

Since this is a computed column, it cannot be used inside the same query.

The options are:

1. Include the salary function in the ORDER BY that...