I'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 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 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...
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've got a sp as below:
The functionality I want to achieve is that when isHomePageFeatured is checked then this record is set to 1 for that column and for all the other records in the table it is set to 0.
This is fine for update as I can use the property Id to compare against, but for the newly inserted record it doesn't yet have a propertyId so I wondered if using newID() to affect all other records would have the same affect.
[Code].....
where can i download profiler from? i can't find it on google.
View 2 RepliesHow 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 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'm trying to create a sql script that will connect to 1 server, backup 2 dbs, then connect to another server and restore the dbs. know i could create an application easily, use sqlcmd too but I wanted to do it on SQL Server Management Studio. I'm running version 10.0.2531.0
View 3 RepliesI have one query which is not responding even after 4 minutes. But same query is when called from asp.net pages (though stored procedure), responds within 10 seconds. My Query:
[Code]....
I don't want to know the ways to optimize the query as I have already changed the query and now it responds within fraction of second. I just want to know that, why it was not reponding after 4 minutes in SQL Management Studio and responds in just 10 seconds when run from asp.net through stored procedure. I am using SQL 2008 Express with Advanced services and .NET 3.5.
i am using sql express 08 & sql management studio exp 08. I tried to clone a database from another but an error occured. My steps:
[newDatabase] >> right click >> tasks >> restore >> databaseOn general section: from database = [databaseSource] >> backup sets: all checked
On options section: overwrite existing database: checked, recovery state: restore with recoveryClick [ OK ] button The error:
Restore failed for 'MyServerSQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
Additional information:
System.Data.SqlClient.SqlError: The file 'x:.........databaseSource.mdf' cannot be overwritten. It is being used by database 'databaseSource'. (Microsoft.SqlServer.Smo)
And why sql management studio tried to overwrite the dataSource (not newDatabase)? how to clone a database? I also tried backup databaseSource to file and then restore newDatabase from the file but resulting the same error.
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 followed the article How to: Create a Database (SQL Server Management Studio)" [URL] I got this:-
//image
Then I tried to add this database in vs08 but at first I got nothing, then I manually started the MSSQLSERVER, after that it just displays the System Databases not the database "test1" I made So how to make it realize that I have made a database and I want it to connect to that database?
//image
i need to connect to the db"test1" so that i can manupilate it using vs08 controls.
I 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 got these errors while trying to run a web application using vs 2008, The first error is this: >Application has generated an exception that could not be handled. >process ID=0x1130 (4400), Thread ID=0xe6c (3692). And when I press OK a second dialog reports this error:>unable to connect to the asp.net development server. I reinstalled, repaired and re registered msdbg2.dll and edited hosts file but still get this error. I need to debug an application but I can't. This error is on a 'Win 2003 server enrterprise service pack 1' with a vs2008 team system installation. What can I do to remove this error and run and debug my application?
View 1 RepliesI 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.
having a table with column having null values
how to identify row of a column contains null value?
i tried isnull,nullif properties but such functions im getting emptied rows
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 a Web App (VS 2010 Beta 2, using VB) and it works flawlessly on the development system. When I publish it, everything works fine unless I use an update panel. If I use the update panel, and try to use something such as a dragpanel, I get the following error.
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E)
Timestamp: Thu, 4 Mar 2010 14:54:25 UTC
Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 404
Line: 784
Char: 13
Code: 0
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI tried to set a Cookies by Response.Chookies("chookie1") into a user's machine and found difficult to get the Cookies by Request.Chookies("chookie1"). I think that is because the person used various cs(User-Agent) (browser names?). Here are some of them:
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1)
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+InfoPath.1
In such case, how can I set Cookies to identify that machine?
Track and identify users with Memcached
View 3 RepliesI work in a multi server , multi webfarm environment (without sessions). We need to be able to identfy if a customer has arrived here for the first or has been before (even though they have not logged in)Not only will we change the text of our salutations depeding on this state but we will also use it in other busness logic. I can check for the existance of a cookie when they fire the Session_onStart event but I would have to write a cookie out to show they had previously visited for the next time the customer came to call.
If I wrote the cookie out in the Session_onStart then somehow I would have to tell the website that this was a first time visit. Also as this is a stateless webfarm - the next server may be different from the previous one which would fire a new Session_onStart event in its own right - which would see the cookie and assume it was not my first visit, even though it was my first visit on a different web page of the web site.
I dont want to write it out and say if its within X minutes of the cookie creation time you are still in your first visit as that x minutes wouldnt work 100% of the time If I dont write the cookie out on Session_onStart then when could I write it out?