i was created one database in SQL server 2005 (INTERNAL VS 2008) but whenever i want to open this db in my friends PC then it generates some Version errors.like Version 655 is not supported.
View 4 Replieshow can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 RepliesI 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 RepliesWhen i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
how can I do it?
View 1 RepliesThis issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 RepliesI am planing to move my sql server 2005 database to sql server 2008 database for my asp.net website. Due do this migration is it I have any issue in sqlserver side or my website will work(sp, views, table) without any issue ?
View 5 RepliesI've been trying to restore a SQL Server 2008 database in SQL Server 2000 and it seems impossible. Does anyone know how to do it or maybe will be able to point me in the right direction?
View 3 RepliesI built a website using SQL 2008 Express. I want to deploy it to a hosting company (shared server). If I change the SQL 2008 Express database on my local machine (further development of the website), how can i synchronize the local SQL database with the one on the server without loosing data?
View 3 RepliesI have SQL Server 2008 R2 Express and Visual Web Developer 2010 Express installed on my PC.I want users to login to my site and add listings that must be linked to their username. ASP.NET generates the ASPNETDB.mdb file when using login / membership function.How do I access this database from SQL server 2008 R2 Express ?
How do I link this database to my own SQL express database?
i m looking for northwind 2008 sample database. But i m unable to get the link. All links are for 2000 samples.
View 1 Repliesi am new to asp.net. i like to learn asp.net and c#. when i try to connect to sql server, it asks server name. i don't know server name and it asks database name also. how to create database and where can i access like phpmyadmin. in phpmyadmin i can create database and tables.
View 9 RepliesI am newbie in SQL Server 2008 R2. I able to created table within it but how do I get the database file. Can I specify the path where the database is create?
View 1 RepliesI used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 Repliesi granted ASP.NET account the sql server database access but ASP.NET seems not able to coonect to the database. I normally do this from code in windows XP, but its not working on my windows seven. i guess it should be something close to NT AUTHORITY in place of the MACHINE/ASPNET account which i have tried anyway but still not working.
View 5 RepliesWe have a database on our server, here at the office. We now want to create a asp.net website that will be accessible to the public.
Say the domain of the website is [URL] and it's hosted on a webserver of HeartInternet.
When someone connects to that domain, that webpage must be able to pull data from our server that is located here in our office.
In other words the webpage cannot just load data out of the MySQL database loaded on its server, but it has to connect to our server and get data.
Is it possible to create a MS SQL 2005 database using Visual Studio 2008?
How about using Visual Web Developer 2008 Express Edition?
I have Visual Studio 2008 and SQL Server 2008 but when i create an SQL Server Database i read that i need SQL Server Express 2005, Why????.....how can i resolve this question without install it but using 2008 version?
View 33 RepliesWEB FRAMEWORK: ASP.NET in C#
I've looked all over the web for something that would show me how to do this but can't find it. I have a page that uploads information about an individual including a resume in the form of a doc docx or pdf. I can upload the file okay but I do not know how to, on another page, To download the file that was loaded to that person's row in the database. Here is the upload code
[code]....
I am using SQL SERVER 2008.
Now I want to access the SQL SERVER 2008 DATABASE on the LAN.
So what was the Connection String and can u give me the Example of that.
How could one set a password on a database in Sql server 2005 & 2008
View 3 Repliesa script which creates a deadlock in a Sql Server 2008 database?I want to do a trace in a customer environment using a trace flag but first I want to test it in my own environment.
View 4 RepliesI jsut installed SQL server and management studio on my PC. For management studio, I created a database with tables. However, When I have data connection for SQL server in visual studio express, I couldn' t see the database I created.
View 1 RepliesI am attempting to write my very first ASP.NET application, it will simply display the contents of an SQL server database table in a Gridview. This is just a first step, my eventual intention is rewrite a set of VB6 applications I wrote some years ago. But I need to walk before I can run.
I have already created an SQL Server database containing all the tables used by the VB6 applications.
How do I link this database to my ASP.NET application. Previously (on another computer) I have simply opened "My Computer" and then navigated to the .mdf file (e.g. northwnd.mdf) and then dragged and dropped it into App_Data in Visual Studio. However when I try that on my own machine, with my own data, I get an "Access Denied" message.
How can I not have access to my own data on my own computer? What am doing wrong?
I am running Visual Studio 2008 on a Windows 7 Ultimate machine, with SQL Server 2005 Compact Edition (or which ever one installs with VS 2008).
It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS the database node is missing.
Before:
After: [:(]
I tried refreshing the database folder but still nothing. I even uninstall but it's still the same.