It is considered a worst practice to call external process from within a trigger.

One thing you could do is create a table with 1 row and a few columns. ...

Run this in query analyser, then paste the results on this query in QA and run the statements.

Select 'UPDATE [' + user_name(O.uid) + '].[' + O.Name + '] SET timekeeper...

One thing I forgot to mention is that maybe the tempdb needs to grow to accomodate for this huge transaction. Maybe somebody else can confirm this.

One simple solution I see is to transform spSEL_Personnel_TEST into a table function that return all the ids.

then simple call

sp_SEL_PProfile_TEST /*no id,*/ 1

Select * from whatever W inner join...

One thing that can slow this to a halt is that the transaction log will have to grow a lot to do the update of ALL rows. That's why...

Functions are executed on a row by row basis. So if you have 5k rows, sql server will have to execute the function 5k times. This can become a...

Here's something that'll work much faster :

Declare @String as varchar(150)

Declare @search as varchar(10)

set @String = 'abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz'

set @search = 'a'

Select (DATALENGTH(@String) - DATALENGTH(REPLACE(@String, @search, ''))) / DATALENGTH(@Search) AS Occurences --division...

Please read this if don't wanna lose your server to an attacker :

The Curse and Blessings of Dynamic SQL

I would strongly suggest that you use the split function...

NP... some of us have figured out it would be something like this. Glad you did too .

I wasn't born stupid - I had to study

You might have studied too hard . (no hurt intended)

Well you could always do something like this :

create temp table

check if file exists

set a fiew variables from the temp table

drop the temp table

exec backupProc param1, param2

Or you could...

HTH.

Actually the temp objects are destroyed when the connection is closed (destroyed ??), but they are unique to each connection. So 1 or 10 users can create the same...

Here's a similar exemple I created on ony of my tables

FkQuestion > 0 AND FAIT = 1

OR

ISNULL(FkQuestion, 0) = 0 AND FAIT = 2

Maybe you're still using a varchar column...

There's just no need for dynamic sql here, check this out :

Declare @Object as varchar(25)

set @Object = 'SysObjects'

Select * from master.dbo.SysObjects where name = 'SysObjects'

UNION ALL

Select * from master.dbo.SysObjects...