Re: SQL Server needs help from MS Access (or something)

javelin wrote:
As for the question, I was suggesting that Access is a good front end
option to enterprise manager and Query analyzer, as it's quicker and
easier to create views and stored procedures. The only thing I don't
like is that you must save a view prior to running any SQL statements,
unlike the query analyzer, which allows you to run code, and then just
throw it away.

Ultimately, I'd like to see an add in for query analyzer that allows
for intellisense features, as well as a strong and easy to use code
repository.

What are your thoughts?

Have you looked at CampaignRunner? It has a graphical query
environment, a central repository, and works great in multi-database
environments. It instantly combines them all into a federated data
network so you can work on all your data. Regardless of whether it is
spread over Excel, Access, SQL Server, Oracle, Teradata, DB2, etc., you
can query and modify your data as if it were all in one single place.

.

Relevant Pages

  • Re: XML Outputs
    ... I am executing these SQL statements in Query Analyzer. ... Can I not create XML documents interactively using Analyzer? ... > With best regards, Alex Shirshov. ...
    (microsoft.public.sqlserver.xml)
  • Re: ADODB.Connection funkiness
    ... multiple servers. ... submit and the all the SQL statements we've typed into the form are ... the semi colon the statement executes. ... GO is a batch delimiter in Query Analyzer, outside of that it has no ...
    (microsoft.public.data.ado)
  • Statement Help
    ... I have two SQL Statements that work great using Access as the front-end, but do not work at all using Query Analyzer as my front end. ... In Access the following two statements return the proper results (both statements accomplish the same thing - They both use a different technique to find unmatched records between two tables): ...
    (microsoft.public.sqlserver.programming)