Results 1 to 11 of 11

Thread: No Stored Procedures or Functions

  1. Jul 29th, 2004, 07:56 AM #1
    Beast777
    Beast777 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    683

    No Stored Procedures or Functions

    I should be able to go to Server Explorer and create a stored procedure or a function as per the help files. I do not have any menu choices or the ability to create them. Any idea why? Here is the MS help on adding a SP. I do not have a SP folder. or the choose new SP on the menu.

    To create a new stored procedure

    In Server Explorer, right-click the Stored Procedures folder or any stored procedure in that folder.
    Choose New Stored Procedure on the shortcut menu.
    Reply With Quote Reply With Quote
  2. Jul 29th, 2004, 08:03 AM #2
    Andy
    Andy is offline
    Frenzied Member
    Join Date
    Nov 2003
    Posts
    1,489
    what version of visual basic are you running? certain versions have limitations.
    Reply With Quote Reply With Quote
  3. Jul 29th, 2004, 08:06 AM #3
    Beast777
    Beast777 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    683
    VS .NET 2003 Pro is what it supposed to be, I was just looking into that. Its version 7.1.3088. How do I find out if that is in fact professional? We bought the pro version but I was not given the originals as they only buy a license and use the selects.
    Reply With Quote Reply With Quote
  4. Jul 29th, 2004, 08:11 AM #4
    Andy
    Andy is offline
    Frenzied Member
    Join Date
    Nov 2003
    Posts
    1,489
    that's the same version I have and mine is Enterprise Architect. I thought it actually said what version it was though. interesting. I will help look into this.
    Reply With Quote Reply With Quote
  6. Jul 29th, 2004, 08:51 AM #5
    nemaroller
    nemaroller is offline
    I wonder how many charact
    Join Date
    Feb 2001
    Location
    Savage, MN, USA
    Posts
    3,704
    Server explorer would be under View - > Server EXplorer if you have it.
    Reply With Quote Reply With Quote
  7. Jul 29th, 2004, 08:51 AM #6
    Beast777
    Beast777 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    683
    I just talked to the IT staff and they cant find the originals, so they are going to order a new copy of the CD's. Is there a difference between Pro and Academic Pro?
    Reply With Quote Reply With Quote
  8. Jul 29th, 2004, 08:52 AM #7
    Beast777
    Beast777 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    683
    Server Explorer is there, and I can see existing SP's. I just cant add or edit one.
    Reply With Quote Reply With Quote
  9. Jul 29th, 2004, 08:59 AM #8
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    I *think* it's only available in Enterprise... but I'm not sure....

    TG
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  11. Jul 29th, 2004, 09:05 AM #9
    Beast777
    Beast777 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    683
    Nope it should be available in Pro. Heres from MS.

    Product/Feature Professional

    Microsoft SQL Server 2000
    Design stored procedures, indexes, tables, triggers, user-defined functions, and other database elements visually. In Visual Studio .NET Professional, these design capabilities are limited to the SQL Server Desktop Engine.
    Reply With Quote Reply With Quote
  12. Jul 29th, 2004, 09:34 AM #10
    Beast777
    Beast777 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    683
    I have found that I can create a SP on the server thru the dataadapter. This is just weird.
    Reply With Quote Reply With Quote
  13. Jul 31st, 2004, 09:03 AM #11
    balmerch
    balmerch is offline
    Junior Member
    Join Date
    Jul 2004
    Location
    Port Huron, Michigan
    Posts
    20
    Pro and Academic Pro should be identical in abilities, but Academic has restrictions on the license.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width