.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Visual Studio vs. SQL Server Management Studio

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :ASP.Net

Dear folks

Am learning SQL Server at a company where I work.

I was curious as to what were the pros and cons of using Visual Studio or SQL Server Management Studio for our development on the database side (i.e. table creation, stored procedure writing, etc.).

What constraint does each choice pose? Pliz advise me.



View Complete Post

More Related Resource Links

asp.net /Visual Studio 2008 Sql server studio management 2008

Hello,I am new to this developing on this platform and having problems at work and home but different problems.  At work when i try and view the aspx page it says unable to connect to the asp.net development server and also can't add the database to the app_data folder.  Are there problems with visual studio 2008 /Sql server 2008?set up at  work is belowL-06914  serverMicrosoft SQL Server Enterprise EditionMicrosoft Windows NT 5.1 (2600)At home, I was making a connection and almost bringing up the page  but had an error the next day could not connect inside of sql server 2008.  At home it is the same except for standard version server is my computer name Let me know if more information is needed. Thanks,  SB

SQL Server Management Studio (2005) and Visual Studio 2008


Help -

I had been using SQL Management Studio, from sql server 2005, reciently I installed Visual Studio 2008 on my machine.  I use it for VB coding.  I still use the same Management studio.  It all works fine except when I try and Export or Import a table in Management Studio using the wizard.  I get the following error:

TITLE: Microsoft SQL Server

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476


Exception has been thrown by the target of an invocation. (mscorlib)


Specified method is not supported. (System.Data.SqlServerCe)



Any help would be appreciated.

Thank you

SQL Server 2008 Express Management Studio fails to install because it thinks visual studio is instal


I tried to install SQL Server 2008 R1 Express with Tools on Windows Server 2008 R2. It installed, but the management studio failed to install because it said I already had Visual Studio installed and it needed Visual Studio service pack 1 before Management Studio could install.

Visual Studio is nowhere to be found in Programs and Features, and when I try to install Visual Studio SP1, it won't install, saying:

A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio 2008 (ENU) product family, and is not compatible with any Express editions.

Though I can't find any Express version of SP1 to try, and there is no SP1 in windows update.


Can't connect to SQL Express 2008 from Visual Studio, but can connect from SQL Server Management St



I've been struggling with the following issue for 3 days:  I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio.  But I can only intermittently access it from Visual Studio (ultimate edition with TF Server).  Sometimes it works, sometimes it doesn't.  I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from within Server Explorer.


Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database.  The database might be unavailable.  An exception of type 'System.Data.SqlClient.SqlException' occurred.  The error message is: 'Cannot open user default database. Login failed.  Login failed for user 'Tim-PC\Tim'.'


I think the connection string is fine as I am able to connect

HttpHandler works with Visual Studio Development Server debugging, but not otherwise


Hi all,

I'm new to HttpHandlers.  I am writing an HttpHandler that reads uploaded files directly from the request stream to provide progress that can be queried using an AJAX request.  For large files, this seems to be faster than having ASP.NET load the file contents into Request.Files and then streaming the file from there to wherever it goes (Linq to SQL into a VARBINARY column in an SQL Server database.)

My HttpHandler works perfectly when I'm debugging using the Visual Studio Development Server, but doesn't work otherwise.  The application pool for this application in IIS 7 is set to run in Classic Mode, and the Handler Mappings screen in IIS says that I must manage managed handlers in system.web/httpHandlers. 

I set up in my applications Web.config file.

<add verb="GET,POST" path="*.upload" type="Namespace.For.UploadHandler, AssemblyForUploadHandler"/>

It works great, so long as I don't debug with the "Use Local IIS Web server" option.

What else do I need to do to get this to work?


Use The Source, Luke: Source Server Helps You Kill Bugs Dead In Visual Studio 2005


The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.

John Robbins

MSDN Magazine August 2006

ATL Server and Visual Studio .NET: Developing High-Performance Web Applications Gets Easier


When developing high-performance applications for the Web, developers often must choose between performance and ease of development. With ATL Server, new with Visual Studio .NET, developers get the best of both worlds. ATL Server uses a tag replacement engine written in C++, provides a simple programming model, and promotes enhanced performance and easy debugging. This article presents an overview of the ATL Server architecture, then creates a basic ATL Server project. It then goes on to explain processing SRF files, HTTP streams, forms, cookies, and header files. Managing session state is also discussed, along with file uploads and performance monitoring.

Shaun McAravey and Ben Hickman

MSDN Magazine October 2000

SQL Server Management Studio


Hi folks


Am sorry if this mght be abit silly question am a Novice Developer.

If am using Visual Studio 2008 Pro, Do I need SQL Server Management Studio? or is it included in the VS 2008 Pro Suite? Am learning C# and SQL Server.



How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

SQL Server Management Studio Slow Grid Draw and Refresh

I've istalled SQL2005/SSMS on my development machine and connecting to a local SQL Server 2005. Executing queries is fast but the results grid populating is slow and so is the refresh of the same data. This is not a slow query, its the gridview draw/redraw. I've other PC's with slower processors and less ram with the same software run circles around the SMSS Performance on this Laptop   I've read posts about nvidia graphics drivers and mouse drivers causing issues similar to this. I do have an nvidia quadro x1600M (this is a laptop Compaq 8710w) and switching off the accelerator using Displays/Advanced/Troubleshooting by moving the slider to the middle/center position causes the gird refresh to dramatically increase. It's funny how turning oof the accelerator increases performance.   I have the latest HP nvidia drivers and SSMS is useable without hardware acceleration  but I also develop software that uses directx and its getting really troublesome to work this way.   I am running:   Operating System: Windows XP Professional (5.1, Build 2600) Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300)Language: English (Regional Setting: English)System Manufacturer: Hewlett-PackardSystem Model: HP Compaq 8710wBIOS: EPP runtime BIOS - Version 1.1 Processor: Intel(R) Core(TM)2 Duo CPU     T7300  @ 2.00GHz (2 CPUs)Memory: 3072MB RAMPage File: 515MB used, 4439MB availableWindows Dir: C:\WIN

Please Help Installing SQL Management Studio (not Express) w/ local SQL Server Express

I have recently formatted my hard drive and over the past few days I've been reloading my software.  I have installed on my machine SQL Server Express 2005 SP3.  I prefer to have SQL Express running on my development machine because that is what my customers primarily use.  I also have a full MSDN license, and I would need to install SQL Management Studio 2005.  However, when I download the SQL Server 2005 Developer ISO from MSDN, and run the setup file I get an error message that states: Installation of Microsoft SQL Server Native Client failed because a higher version already exists on the machine.  To proceed, uninstall the higher version and then run Microsoft SQL Server Native Client Setup. I would assume the problem is that the copy of SQL Server - Dev Edition that is available through my MSDN subscription is using an earlier version of SQL Server 2005 (most likely the version prior to SP1.)  I would just unistall SQL Server Express 2005 SP3 and reinstall it with out any service pack updates.  The problem is that I also see within my Add or Remove Programs list  four SQL Server 2008 R2 entries, that I believe were installed when I installed Visual Studio Pro 2010 (they are, Microsoft SQL Server 2008 R2 Data-Tier Application Framework, Microsoft SQL Server 2008 R2 Data-Tier Application Project, Microsoft SQL Server 20

SQL Server CE in Management studio express

Hello,I am trying to connect to sql server CE trough SQL Management studio express. But it seems like it only wants to connect to an SQL server express instance. Does SQL server CE needs to run as a server? because I can't seem to be able to just connect to a file. Does Anyone know how to connect to SQL CE?Thanks!Greetings,Mark

Using a SQL Server CE database in Visual Studio 2010

I am working on a VS 2010 C# project that is supposed to connect to a Sql Server 2008 CE 3.5 database.  I added the database to the project, and am trying to establish a new SqlConnection. The directory path of the database is: W:\MCT\Development\LocalReportExample\LocalReports\TestCEDatabase.sdf  I am trying to set my ConnectionString as follows: test = @"Data Source=W:\MCT\Development\LocalReportExample\LocalReports\TestCEDatabase.sdf"; connection.ConnectionString = test; connection.Open();  When the code executes, it throws an error message stating that the database was not found, or is inaccesible.  Is my ConnectionString wrong?  Is there possibly something I haven't configured correctly in the database setup?

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

SQL Server 2008 Management Studio

Been around SQL Server since 7.0 days.   In SQL Server 2008 Management Studio I don't seem to be able to display Created Date for Views. I can't really believe MS have taken this away so hence my Q.   I find it useful to see Created Data to script my recently developed View and other objects.   Robert, Edinburgh    Bob as MCSD.NET 2003

Trouble With Team Foundation Server/Visual Studio 2010

Hi At work we are 2 guys on the same project. We both program in visual studio 2010. The other guy complains that he don't see my changes. I know this dude have already executed "Get Latest Version", despite that he don't get my changes. Some more information that may be relevant:Each time I've done some changes to the source code on my local computer, when I run the code breakpoints are not triggered. I get a message saying something about mismatch between different version of the source (or something like that, weeks sinece I saw that message). It's a while since I saw that message becasue I've found a work-around: Each time I've done changes tothe source code I do this:- Clean Solution- Rebuild (Release)- Rebuild (Debug) When I've done that I can see my own changes.. But the other guy have trouble with seeing my changes. I'm not sure how to fix it so that he see my changes. I checkin regulary so my changes should be available on the Team Foundation Server. Any help on this would be very helpful

Cannot Create Database Diagrams - SQL Server 2008 Management Studio

I cannot create a database diagram with my client-side SQL Server Management Studio.  I can do this if I am on the actual db server itself.  Please help.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend