gsquared:

i'm with you now... read your post too fast and didn't get your meaning. doing too many things at once... sigh.

jeffrey williams:

thanks for the info... where is that written and how'd you find it?

it's not that i don't believe you (i do believe you)... i just want to find out...

i can't even do select servername.dbname.dbo.MyFunction() from ssms much less a proc or view...

Invalid Column Name 'CurrentServerName' (or linked server name).

i could swear i posted the error in my first post... i must be losing my marbles...

actually, i did try a linked server... that's how i found this in the first place. i know, a linked server pointing to the local server seems redundant, but we're...

i think linked servers are the answer... i was able to create a linked server to a SQL box and give it my own name. this solves ALL of my...

forgot to include that with aliases, if we add servers and split databases between old and new, i'd still have to update all referencing objects. with synonyms, i'd just drop/create...

ok, so i LOVE the alias thing... it definitely works, and it's definitely usable. and you know there's a "but" coming...

the thing is, i've still got multiple procs, views, queries,...

i like... will check it out to see if it works.

thanks!

i'm trying to get away from using server names in multiple queries. if i used a view, i'd still have to explicitly name the server, so when we changed servers,...

i have not... yet. i'll need to do some research into it first, but if it looks like it might solve my issue, i'll look into applying it.

thanks...

manu,

i've done that. at the moment antivirus is running because it didn't have any effect enabled or disabled. i've also updated the network drivers; i'd read somewhere that people were...

per microsoft's document (http://msdn.microsoft.com/en-us/library/ms159206.aspx), i've been playing around with these settings in c:\program files\microsoft sql server\mssql.3\reporting services\reportserver\rsreportserver.config:

(MemorySafetyMargin)20(/MemorySafetyMargin)

(MemoryThreshold)30(/MemoryThreshold)

(WorkingSetMaximum)1000000(/WorkingSetMaximum)

(WorkingSetMinimum)500000(/WorkingSetMinimum)

the above values are the currently running values, and it seems to...

ok, so knocking on wood wasn't the answer... it just got dumped again. any suggestions are welcomed...

i knew i'd forget something important. it's a 64bit system. i've set min/max memory pretty much all over the board to test different configurations. i've locked pages in memory, but...