But i want Latin1_General_CI_AS which is not a default.

I already have SQL_Latin1_General_CP1_CI_AS., that is the reason why i am trying to re install to change it to Latin1_General_CI_AS

I think using

KILL 54 WITH STATUSONLY;

will give the status but if i already issue KILL without status, how can i generate kill status?

when i executed the same command again...

But when a developer canceled the the query it was still showing as INSERT in the activity monitor and so i killed the session and it appeared as KILLED/ROLLBACK in...

every record of TabA and TabB should match.

sample data

Code1 Code 2 Code3

865986239354

865986239354

865986239354

NULL NULl NULL

something like this where in all the Code column in one server is char(5) and the other is varchar(5)

select h3.code1,h3.code2,h3.code3,h6.code1,h6.code2,h6.code3

from hock3.obever.emp h3 inner join

hock6.obever.emp h6

where h3.code1h6.code1 or

h3.code2h6.code2...

If i have a single pkg in msdb , can i use it for multiple jobs simultaneosly.

what I mean is i have a pkg where in 3 jobs use it,...

that means if i import any pkg from msdb and edit it in BIDS then does the change also effect original pkg in msdb database or is it a local...

that means both will have uniqueness but the only differnce is clustered index will allow NULL but PK doesnt.

Do you mean to say running them simultaneously will take long time comapred running them one by one?

wait time on the total process is 30526656 CXPACKET and i see...

all of the tables are not related, they are completely independent.

why do i need to limit the number of processors when i have 7 CPUs i want the job to use as many as it requires and finish the job...

You can also reduce the impact by setting the max degree of parallelism setting for the server to 1/2 the number of cores. Reduce even further if you are still...

yes i did get the result i need but i would like to add 1 more functionality to it.

how would i compare from one parameter to other like say..

compare between...

I think my question was is not clear, let me explain it.

I have 3 parameters for my store proc and i would like an IF or CASE statements to select...