I've just downloaded SQL Server Management Studio 2008 after using SSMS 2005 for the past years, however the intellisense isn't working in the Query-Builder. I've checked, and Intellisense is enabled. Is there any other reason this could not be working?
View 4 RepliesI restored a database from another server, and everything looks good except the users.
I'm managing all this from SQL Server 2008 Management Studio as SA.
The users are present in the [u]databaseName > security > users[/u] section, and they exist in [u]databaseServer > Security > Logins[/u]. However I can't change anything in the [u]databaseName > security > users[/u] section, because when I try and make a change, and then I hit OK to apply, it says "[i]login name must be specified[b][/b][/i]". But the login name field is grayed out and I can't modify it(even though I'm logged into the machine as Administrator and SQL as SA).
Also, in the user mapping section, when I try to map one of the users to a database, it says '[i]create failed user already exists[b][/b][/i]'...but I don't want to create the user, I just want to map that user to the appropriate databases...
where can i download profiler from? i can't find it on google.
View 2 RepliesI sucessfully installed SQL Server Express 2010 on my windows server. I then tried to install the SQL Server 2008 management studio via Web Platform Installer but it failed (it did however sucessfully install powershell).
[Code]....
I have instance of MS SQL Server 2005 on my computer. Is there any way to install SSMSE (Management Studio) 2008 to work with instance of MS SQL Server 2005? Operational System of my computer: Windows XP with 32 bit, processor 1.67 GHz.
View 2 RepliesI installed MS SQL Express 2008 with Advanced Services including Management Studio 2008. When I connect to the SQL server of my provider (shared hosting - one SQL server for many customers), it takes very long (up to serveral minutes) until all DBs are displayed in the object explorer (from which I then have to choose my DB). Somebody told me, the long waiting time occurs because Management Studio first checks rights (whichever rights that may be) with every DB that runs on the server.
But in Management Studio 2005 the behaviour is different - the DB Tree in the object explorer expands immediately! No waiting time! Does anyone know a solution for this? I don't want to install two separate versions of Management Studio just because of that!
I have SQL Server Standard 2008 installed on my machine, alongside Visual Studio 2008.
My current hosting provider (not a huge fan) requires me to access my db's remotely via SQL Server Management Utility. To date, I've been doing it by connecting remotely in VS2008. Their troubleshooting documentation/steps, though, are for the SQL Server Management Express 2008, and i'm having a lot of connectivity issues with them.
I followed the steps here: [URL] to "add additional features to an existing installation" - but when I did so, the setup wizard indicated that the Management Tools-Basic were already installed.
I have installed a vs 2010 ulitimate . it's have Sql server 2008, but i want to Open SQL Server Management Studio 2008,
View 1 RepliesI have been given a .NET type web hosting by my provider along with MSSQL. I am learing what that means and how to use it. Can I use my SQL Server 2008 Management Studio to connect to that SQL over the internet in order to put my database on the web? or how else can I use it?
View 1 RepliesI have just installed SQL Server 2005 on windows7. It was installed successfully. When I tried to open SSMS it became faild. It gives me SQL Server Error :18456 Login Failed. How can i find what server name I put to login? Because when It prompt me to login, in server combo box it shows me only <browse for server> option and it doesn't show me any option to select server. I put the default John-PCJOhn it gives me an error. I uninstall it two times and installed it again but every time it gives me same error. It was working fine before formating my laptop. Please give me a solution to login in to SSMS.
View 4 RepliesI am having a problem connecting to my SQL Server 2008 Express database with SQL Management Studio Express and from the website at the same time.
Everytime I want to view any pages in my site that access the database, I have to close management studio and restart the server for some reason or i get a failed login error message. Then when I want to go back to SSMS I get this error message:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
Additional Information: Unable to open the physical file c:..... Operating system error 32: "32(The process cannot access the file because it is being used by another process.)" (Microsoft SQL Server, Error: 5120)
Is it NOT possible to work on the database through SSMS at the same time as viewing pages in the website that access the database?
I sure hope that there is a work around or something for this.
Just in case my connection string is:
<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
I want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 RepliesI'm a beginner with ASP.NET. I'm using SQL Server2005 Management Studio. The problem I facing is arises when I tries to run any query,even the simplest, it doesn't identifies the table. as below:
View 4 RepliesWe use SQL Server 2005 and 2008 here at my workplace. In the past, whenever we setup a new developer workstation we would install Visual Studio, then install Management Studio by downloading the SQL Server trial, and installing only the tools. The tools (in the past) were setup so you could use them indefinitely, it was only the database engine itself that was time-limited.
With SQL Server 2008 that has apparently changed. I tried to start Management Studio 2008 on my workstation today, and got an error stating that "evaluation period has expired." I'm assuming we built this workstation the same as all the previous ones we've built, but now that I'm thinking about it I'm wondering if possible Management Studio was installed along with Visual Studio... is that possible? At any rate, my question is--how do we properly install Management Studio so that it won't "expire"? We don't need to install the database engine, we just want to install Management Studio.
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, MyPCNAMESQLExpress
nothing is working, getting this error:
-----------------------------
Cannot connect to PC-NAMESQLEXPRESS. 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)
----------------------------
How do you import database diagram at SQL Server Management Studio Express (SSMSE)? Using SSMSE in checking my database through a shared server, the "Database Diagrams" folder has no import functionality.
View 1 RepliesAs I wanted to try out the new VS, I started and began working on a C# web project that I had previously started in VS2008. So far, so good. But then I noticed that Intellisense is not working at all. I have done some searching, but all I could find were some problems with the release candidate version crashing.Does anyone have any insight as to what might be causing this and how to resolve it?
View 3 RepliesI thought I would try this forum first, but it may be an ASP.NET general question.
I have setup profile in a web.config like the following:
[Code]....
However when I try and reference the profile in a code behind using the "Profile.blah-balh" the intellisense does not pick up the elements I have defined in the web.config.
Intellisense is generally working and does sport the Profile() starting point when typed.
I have the developers edition of sql server 2008 on my local machine (I have an msdn subscription). I would like to download and use r2 client, which I understand is superior to the standard client) but not the express database. Do I want the "SQL Server 2008 R2 Express with Management Tools " (doesnt sound like what I want) or the "SQL Server 2008 R2 Management Studio Express" (does sound like what I want, and is about 100M smaller, so I assume doesnt load the database). Of course I am assuming that the r2 client connects with no problems to a non-r2 database.
View 2 RepliesI have a JavaScript wrapper that I initialize on body load and set to a global variable.
Just after creating the object, I have full intellisense, but when referring to it later, from another function, the intellisense is lost. I presume this is because of dynamic typing:
var myWrapper;
function onload() {
myWrapper = new Wrapper(args);
myWrapper. //intellisense here.
}
function whatever() {
myWrapper. //intellisense lost.
}
I get round this by pretending to create the object again before my code, and then deleting the line:
function whatever() {
myWrapper = new Wrapper(); //pretend to create object again.
myWrapper. //intellisense returns!
}
Has the inference been improved in vs 2010, or is there any way to tell Javascript about the type of object I'm currently working on?
When I edit in a asp file, the intellisense does not work for any ADODB objects with vs2008(sp1) in Windows 7.For example:Set conn = Server.CreateObject("ADODB.connection")
.. And next line I keyin "conn". Then keyin ".", but it does not popup the intellisense menu for ADODB.connection.But, the native objects for asp, such as Request, Response, Session, Server.. etc., them popup the intellisense menu correctly.Or some other objects, such as "CDO.Message", them work fine !
I have recently upgraded to SQL Management Studio 2008. The first thing I noticed is it wouldn't allow me to save changes to my table structure at all. I fixed this by disabling "Prevent Saving Changes that requre table re-creation" under Tools..Options...Designers...Table and Database Designers. Now it lets me save. However, if I rename a column in a table that has data in it, I get a warning telling me my data will be lost since the old column will be gone and the new column has no data in it. Since when does renaming a column require a table to be recreated? Is this some sort of setting in SQL Management Studio? If I can't don things like rename clolumns (even change column data types) without losing all my data, then what is the point of using SQL management studio?
View 2 RepliesI am using Visual Studio 2008 SP1
I have two master pages: TopLevelMaster and NestedMaster
When my page points to NestedMaster as it's master page, intellisense quits working in the .aspx page.
If I change my page to use TopLevelMaster as it's master page, intellisense works.
No matter what I use as the master I always get a green squiggly underline under the Content control that brings up a tooltip that says "Could not find ContentPlaceHolder1" in the current master page or pages"
TopLevelMaster exists in a different project than NestedMaster and the page.
When I say "intellisense quits working" here is what happens:
If I type something between the Content tags I get no intellisense for asp controls:
<asp:Content ID="Content1" runat="server" etc.., etc..>
Only html controls appear upon typing an open angle bracket here
</asp:Content>
If I instert a div element I can type an opening angle bracket and I see a list of all asp controls. If I choose one and start typing there is no intellisense after that:
<asp:Content ID="Content1" runat="server" etc.., etc..>
<div>
ASP controls appear but no intellisense other than asp:ControlName
</div>
</asp:Content>
Opening one or both master pages in the IDE has no effect.
I deleted Visual Sudio temp files.
I follow the instruction of installing a new feature with the application SQLManagementStudio_x86_ENU.exe and I get to a fail telling me that VS 2008 needs to be upgraded to SP1.
This I have done several times with the final message saying successfully installed yet 'About' shows only
Microsoft Visual Studio 2008
is it possible to put my database in the system databases in the program ?
View 2 Replies