Re: SQL 2005 Synonym in VFP Data Explorer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Anders,

Yes, I know that synonym definitions are in the system table sys.synonym of
the database, I can see it in SQL Server Management, but... how could I
retrieve all the synonyms of all my databases in VFP Data Explorer ?

I need to extend Data Explorer in this way, I know where are documentation
and sources, so... let's go :-(
--
www.AtoutFox.net


"AA" <A@A> a écrit dans le message de news:
OSXdfo9WGHA.4652@xxxxxxxxxxxxxxxxxxxxxxx
I can't see them in the Data Explorer but any synonyms in a database are
listed, documented and working in 'Microsoft SQL Server Management Studio
Express', which is free and distributable.
-Anders

"Michel LEVY" <stop.michelvfplevy@xxxxxxxxxxxxxxx> skrev i meddelandet
news:uuBfmluWGHA.3740@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a lot of synonyms in a SQL Server 2005 database. How could I get
them into VFP Data Explorer ?






.

Relevant Pages

  • Re: Delete old WSUS 2 Database files
    ... In SQL Server Express Manager Poo Bah, or what ever its proper name is you can see on one of the screens which copy of the WSUS database "susdb" is being "managed" by the manager. ... If you have a copy of SQL Server Management Studio on that server, ...
    (microsoft.public.windows.server.sbs)
  • Re: ASP.NET Membership tables dissappear when db is attached to a different sql server instance.
    ... Connecc to Computer A using SQL Server Management Studio, ... Go to location of database file on Computer A, copy file to a location on ... Connect to SQL Server instance on Computer B using SQL Server Management ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Creating a database in Compact edition? Help>>>>>
    ... Use the SqlCeEngine object to create a database in code. ... Setup syncronization with a SQL Server Workgroup or better DBMS. ... The Express edition of SQL Server Management Studio does not support CE. ...
    (microsoft.public.sqlserver.ce)
  • Re: Dynamic database selection?
    ... When you move to a new database you only need to update the synonyms. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Using updatable views when moving tables from one DB to another?
    ... In the new version of the database, ... Right, if you are also changing column names or anything else, synonyms ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)