why to use xp_cmdshell when you have the ability to write assembly it NET, more then that, that can be signed and give a higher level of security?

we are not...

fixed the C# code :

SqlCommand cmd = new SqlCommand("casp_GetExist", cnt);

SqlParameter parameter = new SqlParameter();

...

i used the MaxErrorCount solution its good for now

thanks

solved

select CASE WHEN MIN(t.r) = 1 then t.name1

ELSE ''

END as name1,

t.name2, t.name3, sum(t.sum1), sum(t.sum2)

from (select *, ROW_NUMBER() over(partition by name1 order by name1) r

from #tbl1) as...

this is the url to the image

Jeff Moden - your correct, one of the most important things that RAISEERROR gives you is the ability to log to the application log, which lets you monitor from outside...

yes

first one

no trigger

and the query immediately after the update

i am adding the execution plan

thanks for any help:)

Hi Ron, can you share with us the package?

how do you clean the diffrent statistics, so on next run time, you will get only the data from the previous time?

it seems that if you dont work in a domain the use of certificates is a must!

any way i did all the steps, but the last one isnt working :

ALTER...

different disk as physical disk (not partitioned).

first thanks - i will check it out.

i understand that that i need to run the 2 commands from the principal server? and if yes, how does it know to...