The stored procedure calls another package?

Have you added some debugging routines in the package to see if it actually executes?

I would create a small program outside of sql server that does this. (datasets in .NET?)

You could also try to store the outputs in temporary tables.

For text-files you might consider...

With the stored procedure sp_who2 you can see which connection is blocked by another connection. Then you could kill the offending connection (beware of the rollback).

Current locks: sp_lock

It might be solved by increasing the mem to leave area to 512mb instead of the default 128mb.

-g 512

Usually the recovery time is less than 1 minute, undo operations excluded.

Are there any long running transactions on the database?

Does uid.test_sp exist in the database NorthWind? And does uid has execute permissions on uid.test_sp?

Have a look at

http://www.sqlservercentral.com/articles/DTS/dtsandglobalvariables/2266/

There they assign values to global variables.

Wow, megajoins.

Do the joinable fields used in the query have an index? (the id fields)

Do the queryfilter fields have an index?

A:

Perhaps an index on T1.OWNER_EMP_ID and an index on...

If it needs to be clustered, always add the "clustered". Defaults can change over time.

You could look for some spacemonitoring-scripts.

A basic loop across the tables and

the stored procedure sp_spaceused might work also.

*edit*

have a look at http://www.sqlservercentral.com/scripts/tables/62545/

There is the deny right that overrules allow. If an user is member of a role which has deny update on table X, the user can't update it even when...

Doesn't AWE require fixed memory instead of dynamic allocating?

Up to date with servicepacks (sp4 has an AWE bug fixed by a hotfix)

Please share your solution

Can you give an example of phone1 and phone2 and the desired result?

Wild guesses:

update members

set [mobile]=phone1 + 'separator' + phone2

where ...

update members

set mobile=firstmatch

from members

inner join

(

select memberid,

CASE PHONE1 like ......

Seems like an ODBC-function.