June 5, 2003 at 8:19 am
Hi there,
Dunno if this is what you would call it, but i need to create a database wide variable. Its a script which uses a remote server name and i'm developing it (and lots of other scripts) on a development server using a remote development server. When i put it live, the hardcoded name will have to be changed everywhere. Is it possible to set it up for the whole database (hope that made sense...)
Thanks
Meg
June 5, 2003 at 8:35 am
Why not store it in a table?
June 12, 2003 at 5:42 am
I agree with jpipes, store the value(s) in a table, this is the way Microsoft (and Sybase) store lookup values.
See master.dbo.spt_values as an example. (I have read articles referring to this table as "The Mother of All Lookup Tables"!!)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply