How can I do this server wide?

BOL very helpful......

used

sp_configure 'show advanced options', 1;

GO

reconfigure;

GO

sp_configure 'cost threshold for parallelism', 10;

GO

reconfigure;

GO

RECONFIGURE

-------

EXEC sp_configure 'recovery interval', 90

RECONFIGURE WITH OVERRIDE

GO

worked! THANKS

HA! That makes sense.... sometimes I'm slow....

thanks I'll take a look and see what I can find. much appriciated.

Well I'm not sure if I can modify the query as it's hardcoded within our application....but I could be wrong. New to this but what is BOL?

How can I set up a data replication filter? That seems to me the easiest way to accomplish this

Nope don't care.....just need 4000. I'm a little green in my query writing so any assistance would be FABULOUS!

apologies I didn't word that correctly....I just need only 4000 records replicated vs. the 30,000 some records. These are patient records so I will need just 4000 patients and the...

actually at this point I don't care about it being datetime or not...crystal won't even pull the start date or end date correctly.....any help would be appricated.

Crystal didn't like that either....

the datatype is datetime for mwappts.adate however the problem lies with the script being used within a crystal report and I can't have a datetime format...I just need date. So...

Thank you so much.... do I need to change this statement as well

DECLARE csrTables CURSOR FAST_FORWARD LOCAL FOR

select name, 'select '+CHAR(39)+'I'+CHAR(39)+'+ACCOUNT as NewAcct, account as '+name+' FROM '+name+' WHERE left(account,...