October 1, 2003 at 10:11 am
All--
Once upon a time (during the heyday of VB6) I was able to view T-SQL code in the VB6 IDE and edit tables and stored procedures directly. After I submitted my changes, the IDE would respond with the appropriate ALTER TABLE or ALTER PROCEDURE statements and ask me whether or not I wanted to continue with my changes. Life was good.
Now flash forward to VB.NET. I am only able to view table structures, and can only view stored procedure parameters. No longer am I able to make edits directly from the VS.NET IDE. Is there something I need to do in order to get this capability back, or is VS.NET not set up to do this? I am 'dbo' on all tables within the databases with which I work with all necessary table- and stored proc-modification rights. (Note that I am using integrated Windows security.)
Please advise. This is not a must-have, but it is certainly a nice-to-have, considering I could do it in VB6 without breaking a sweat.
Thanks,
Regards,
Matt Seltzer
Senior Database Analyst
NYU SoM Child Study Center,
New York, NY 10016
October 1, 2003 at 4:25 pm
I use the VS.Net IDE to edit all my SP's. I simply create a database project and then add connections to the Server Explorer window. I probably have 25 database connections to separate machines at any one time in my project. I can also easily save my SP's to a file and add them to my project. The files then get added to my source control as needed.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 1, 2003 at 5:58 pm
...OK, so explicitly creating a Database Project within my overall solution is the key to doing this? Thank you, I will try this ASAP. (I really miss the way VB6 used to do this <*sigh*>, LOL!)
October 1, 2003 at 6:19 pm
If you make the Server Explorer visible you should be able to set up a connection to the server. I always use the C++ environment but it should be the same for VB now.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 2, 2003 at 9:44 am
Hello, Gary,
Oddly enough, I am able to use VS.NET 2002 to generate Create scripts, Change scripts, etc. on my laptop (which has MS SQL 2000 installed). I cannot to the same on my (much beefier) pc at work. In both cases, I am connecting via integrated NT security. Also, in both cases, the MS SQL Server Client Tools are installed. All other things being equal, what security settings, database role settings and/or Registry settings are necessary to turn on this VS.NET functionality?
Thanks,
Regards,
Matt
P.S. It just dawned on me that I am using VS.NET Academic at work, and VS.NET Enterprise at home. Could that account for the difference? Is the Academic version lacking in this area, and, if so, is there a workaround?
TIA,
Matt
October 2, 2003 at 6:03 pm
Matt,
I've never used the Academic version although I would be very surprised if it were different in this area. As for what security settings are needed I have not looked into that as I'm sa on every box I work on. I also use trusted connections on all my connections. If you switch to a SQL Server user instead does that help? Maybe SQL Server is having trouble resolving your user information.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 3, 2003 at 7:43 am
Hello, Gary,
No joy in Mudville, yet, but I've noticed two more possibly significant facts: my home laptop is running MSDE 2000 (and VS.NET Enterprise). At work, I am running MS SQL Server Personal Edition (with VS.NET Academic). I seem to remember reading something about limitations of Personal Edition w/regard to using VS.NET (_any_ edition) to edit tables, stored procs, etc.
Please comment.
Thanks,
Regards,
Matt
October 8, 2003 at 2:40 pm
Matt,
Sorry for the delayed response. I'm extremely busy lately trying to implement a new database design. I have no experience with any of the academic versions nor the personal edition of SQL Server. I always use the developer edition (if on XP or Win2k Work Station) or a full blown enterprise edition.
Unfortunately I just don't have the time right now to create a machine with your setup to test and find out what the problem is. 🙁
If I hear of anything like this I will post again. Sorry I couldn't help you more!
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply