v2000 umm...

Have you tried running sql server setup and see if there is an option to add replication to an isnatnce?

the parameters are probably transfered as a csv string.

so '1,4,2,6'

x in ('1,4,2,6') where x is an integer will give an error as it tries to convert '1,4,2,6' to an integer.

You...

Would have thought with this question it would be quicker for someone with a few minutes to read it as it is rather than look at table structures and test...

The index you suggest will be covering for the same queries as the other 3 indexes so should help.

The real question whether the queries affected need help or would the...

I would guess from the question

custid, dte, bal.

Sample data should be easy to create if you need it.

Think what you want is to give i/o priority rather than allocate disk space.

Also think the answer is no.

Can you put these on different instances?

something like

select distinct custid

from

(

select custid, baltype, ROW_NUMBER() over (partition by custid, baltype order by dte) as seq

from

(select custid, dte, baltype = case when bal >= 0 then 1 else 0...

SELECT chartnumber, Dataofservices,CPT,Amount FROM TABLE1

union

SELECT chartnumber, Dataofservices,CPT,Amount FROM TABLE2

EXCEPT

SELECT chartnumber, Dataofservices,CPT,Amount FROM TABLE1

INTERSECT

SELECT chartnumber, Dataofservices,CPT,Amount FROM TABLE2

Another option is to not nest transactions. Have a single point of control.

i.e. only the level that starts the transaction commits or rolls back.

Get gzip and use xp_cmdshell to execute an os command to do the zipping.

Could use other zip utilities but I tend to favour gzip.

Have a look at

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/16fd90cf-0dbc-4012-9970-6ca29b6f4aef

Have you tried changing Mutual Authentication Required to No Authentication Required?

I've had this issue before and got round it somehow. I'll see if I can find the code.

It might have...

Nope.

Mainly because it's easy to write scripts to do it.

If people use maintenance plans then they tend not to understand what is actually being done and get into trouble when...

FROM "001".dbo.imitmidx_sql imitmidx_sql

left join "001".dbo.edablkfl_sql edablkfl_sql

on edablkfl_sql.item_num = imitmidx_sql.item_no

left join "001".dbo.edapkgfl_sql edapkgfl_sql

on edapkgfl_sql.code = edablkfl_sql.package_code

left join "001".dbo.iminvloc_sql iminvloc_sql

on iminvloc_sql.item_no = imitmidx_sql.item_no

where imitmidx_sql.activity_cd='A'

AND imitmidx_sql.item_no Not Like '%-FS'...

select m.*

from Main m

join tbl_filter f

on f.code = m.code

and f.centre = m.centre

where m.code not in (select code from tbl_filter where center is null)