jwcolby
jwcolby at colbyconsulting.com
Thu Jun 5 07:33:23 CDT 2008
Arthur, I am not shipping databases so any discussion of that is a moo point to quote Joey from Friends. I have many different databases, all running ATM on the same server, though they are backed up to a neighboring server. I am standardizing the tables in the individual databases such that each has exactly the same field names and set of fields. Thus I need a single set of SProcs that work on any of the databases. I do not want to have to "go" to that database to get them to run, in fact I want to "go" to a single database and be able to run the SPRoc on any of my databases. Thus it appears that the "company" database is the answer. If I do need to move any or all of the databases to another server, then I just copy the company database along with the individual databases. The living accommodations sound delightful. Work hard, make a lot of money and enjoy your time in the sun. John W. Colby www.ColbyConsulting.com Arthur Fuller wrote: > Yes I'm in my new home and on day four of my new work environment. The > company found me "temporary" digs (three month lease) so I had a starting > point from which to investigate the alternatives. It's a one-bedroom flat > with marble floors and a yard with lots of plants and several walk-in > closets, and it's a five-minute walk from a stunningly gorgeous beach called > Coco Reef. There's a luxury resort hotel there, from which I'm renting the > flat, so yesterday I went there to have dinner on the deck. Brought my > notebook and sat facing the ocean and effortlessly hooked into their > wireless and wow, that's my notion of an office! I can definitely grow used > to this. > > The 'company' database works too. There are tradeoffs in every approach. You > can call sprocs in db1 from db2 by specifically citing the full object name, > but then if you ship the db to a client then you'll have to ship two dbs not > one. Not that there's anything wrong with that, in fact it might have the > same advantage as it does in Access (e.g. libraries). > > Arthur > > On Wed, Jun 4, 2008 at 1:49 PM, jwcolby <jwcolby at colbyconsulting.com> wrote: > >> Arthur, >> >> Are you in your new home now? From previous emails it >> sounded like this was move week. >> >> So what do you think of the "have your own 'company' >> database" into which you throw these things. They would be >> all in one place now. >> >> John W. Colby >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >