Hi all. just wanted to let everyone know i've stored all my procs in a central db and have set up replication to keep all the other dbs in...

yeah, i'm kind of ribbing my boss a little; his reasons for maintaining separate dbs are solid, just not from a db design point of view. i think PCI...

Lowell - that worked man. awesome!! Thanks so much!

The rest of you - to answer the main question: i do have a handfull of databases that are exactly...

i use a nice script from sqlmag:

SELECT

t.name AS 'Table',

SUM(i.user_seeks + i.user_scans + i.user_lookups)

AS 'Total accesses',

...

thanks. i do indeed use central functions for things like string/date operations. But my problem is getting the procs to work with data in the correct db. ...

That certainly seems to be the case. I just can't imagine why an IP address would not be acceptable. I mean, what's so great about a servername? ...

wow. guys, thanks for all the advice. I am feeling pretty stupid right now telling you what actually happened was due to a bug (i am almost positive)...

it really depends on how easily you can connect the servers. if you have linked servers and can query directly from one to the other, i'd just do it...

i guess what i am say is that it would be helpfull to be able to search only those questions / topics that have been answered corrctly and solved the...

You need to be a little more clear about the tables you are dealing with. i am having a hard time figuring out what it means to group by...

is there a way to mark a topic as finished, or mark that the question has been answered correctly/helpfully? seems like this would be quite a useful feature.

-d

Fantastic. Thanks for everyone who took the time to think about, and reply to, my question. Thanks especially to RBarryYoung who's solution elegantly solves the whole problem. ...

the discrete steps were just to load the data for the example. The actual insert is a bulk insert in the form of

Insert into TableA(ID)

select ID from TableB

so, lots...

whoa. dude really needs an editor.