You are here: Re: Dynamic database selection? « MsSQL Server « IT news, forums, messages
Re: Dynamic database selection?

Posted by Ed Murphy on 06/15/07 22:12

Erland Sommarskog wrote:

> Ed Murphy (emurphy42@socal.rr.com) writes:
>> The problem is that the name of the source database varies from
>> one system to another, so I want to pass the database name as a
>> parameter. I think I could do the following, but is there a
>> better way to go about it?
>
> On SQL 2005 you could use synonyms:
>
> CREATE SYNONYM mytable AS thatdatabase.dbo.hertable
>
> When you move to a new database you only need to update the synonyms.

Alas, this is SQL 2000 (or at least I expect it will be in a
significant number of cases).

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация