Re: VS.Net - Opening SQLS2k Stored Procedures in the IDE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Douglas Buchanan (dbuchanan52_at_hotmail.com)
Date: 10/26/04 

Date: 25 Oct 2004 22:23:59 -0700

Mary,

Thank you for your reply.

Yes I am using SQLS2k.

I certainly can use Query Analyser, and it is local on this machine.
However since the IDE is supposed to be integrated with SQLS2k I was
wanting to explore that functionality.

(The fact is I have two systems with VS.Net and SQLS2k installed, A
laptop (WinXP) and a server (WinSBS2k3 Premium). Both of these are
missing the funcionality I referred to.)

With your advice I will consider putting my efforts exclusively to
using Query Analyser.

Could you direct me toward articles or resources on the "Best
Practices" of developing db windows form projects with VB.Net and
SqlS2k?

Thank you,
Doug

Mary Chipman <mchip@online.microsoft.com> wrote in message news:<nmfqn0t6bk6uk331qe94s20tku49euosim@4ax.com>...
> Are you in a database project? In any event, you should consider using
> the Query Analyzer (and the other SQL Server client tools like
> Enterprise Manager) for creating database objects because they have
> more complete functionality for creating, securing, optimizing and
> securing SQL Server objects.
>
> --Mary
>
> On 24 Oct 2004 20:54:36 -0700, dbuchanan52@hotmail.com (Douglas
> Buchanan) wrote:
>
> >I can't seem to open SQLS2k Stored Procedures in the IDE
> >
> >I am running MDE 2003 Version 7.1.3088
> >I have a MSDN professional subscription and did a complete install of
> >vs.net
> >
> >Help explains how to do it:
> >
> >1. In Server Explorer, expand the Stored Procedures folder.
> >2. Double-click the name of the stored procedure you want to open.
> >-or-
> >Right-click the name of the stored procedure that you want to open,
> >and then choose Open on the shortcut menu.
> >The stored procedure is opened in a text editor that you can use to
> >edit the SQL statements.
> >
> >In tutorials I have seen the stored procedure was dragged into the
> >work area.
> >
> >None of that works!
> >
> >When I Double-click the stored procedure it just expands to show the
> >parameters
> >
> >When I Right-click the name of the stored procedure the shortcut menu
> >shows
> > Run Stored Procedure
> > Refresh
> > Copy
> > Properties
> >
> >When I drag the stored procedure into the work area it gives me that
> >circle with slash (the 'can't' or 'no' sign)
> >
> >Other related functionality; i.e. Creation of Stored procedures is
> >likewise un available.
> >
> >What should I do to gain this functionally?

Relevant Pages

  • Re: Status Column in sysobjects table...SQL2000
    ... I mean when the same piece of code i.e. the stored procedure is compiled ... in the query analyser compiled manner. ... "Dan Guzman" wrote: ... >> I am not sure if there is any way to get this undocumented information. ...
    (microsoft.public.sqlserver.programming)
  • Re: User ID and Password in the Query
    ... Pro SQL Server 2000 Database Design - ... > How can I pass the user id and password in a simple SQL statement. ... I am logged into a database. ... Without logging into query analyser with his credentials(I had ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL server rename
    ... Execute a update statistics for all tables ... Execute a DBCC CHECKDB on the database and analyze the log ... > I had to rename the server that I am running sql server 2000 on. ... > If I use query analyser I can connect to the database no problem. ...
    (microsoft.public.sqlserver.setup)
  • Re: ISQL call problem
    ... I`ve opened a Query Analyser and write the ... you must open a command-line window. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: OLE DB CAccessor problem
    ... > Now, I have tested my stored procedure using the Query Analyser, and I ... I don't have any experience of the consumer templates - I access the ... I tried using your syntax with my setup, ...
    (microsoft.public.data.oledb)