sql-server-2008-express Questions
4
Solved
I am using Visual Studio 2008 and SQL Server 2008 Express.
How can I change the name of the view? I can change tables' names, but I can't change the view name.
Any suggestion?
Dyanne asked 10/9, 2009 at 0:10
18
Solved
I have an MS SQL Server 2008 Express system which contains a database that I would like to 'copy and rename' (for testing purposes) but I am unaware of a simple way to achieve this.
I notice that ...
Presidentelect asked 30/9, 2010 at 9:16
3
Solved
When I open the Management Studio and try to connect using the [PCNAME]/SQLEXPRESS it shows this error:
"Cannot connect to [PCNAME]\SQLEXPRESS"
ADDITIONAL INFORMATION:
Error Message:
A n...
Erose asked 10/5, 2012 at 23:5
13
I am newbie in this .NET and please don't mind in answering my simple question.
I am trying to write a windows application, where in I am using a localhost SQLserver for database.
I need to know w...
Anthropologist asked 27/12, 2013 at 6:57
5
Solved
It installed automatically with Visual Studio 2010 Ultimate. I didn't create any users for the server or ANYTHING.
I'm using:
string connectionString = @"Server=.\SQLEXPRESS;Database=SportsStore;...
Germinant asked 7/8, 2010 at 14:20
1
Solved
I am using MS SQL Server 2008 R2 SP2 Express edition, 64 bit.
I do not have access to the Database Mail setup wizard, but the Binn directory contains DatabaseMail.exe (v10.50.16600.1) and DatabaseM...
Snicker asked 24/11, 2015 at 21:49
5
Solved
I am in charge for migrating old Access 2007 project to MS SQL server 2008 Express. The first stage is to move all the data from MS Access database to SQL server while keeping the Access forms and ...
Ophite asked 1/2, 2012 at 9:12
3
Could anyone please explain to me how to create jobs in SQL Server Express edition?
Amphibian asked 26/8, 2011 at 6:54
7
Solved
Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it?
i.e. it won't work with sql express
Useless asked 9/2, 2009 at 14:28
1
I am trying to allow remote connections for SQL Server Express. When I connect from machine A to connect to SQL Server on machine B using Visual Studio, I get an error:
A network-related or inst...
Brezin asked 18/4, 2014 at 21:31
6
Solved
My hosting provider (Rackspace) is offering a fully managed dedicated server with SQL Server Web version () installed. My company handles web development, and has about 20+ clients using ASP.Net + ...
Christiansand asked 23/7, 2009 at 4:36
2
Solved
I've come across this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 and I am a bit confused about the different versions here.
So I would like to know what is the difference b...
Sickler asked 23/6, 2012 at 14:20
3
Solved
A database that was originally from SQL Server 2008, was restored into SQL Server 2012. A backup from SQL Server 2012 was made and I am trying to restore it on my local SQL Server 2008 Express. How...
Indefinable asked 25/5, 2012 at 10:56
2
Solved
Does SQL Server 2008 Express support Integration Services? When I try to create an Integration Services project, it says that I have to install Integration Services, but I cannot find the option in...
Akira asked 20/3, 2013 at 3:8
3
Solved
Possible Duplicate:
Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
I am new to SQL. I am trying to write a INSERT query in SQL se...
Gristmill asked 3/10, 2012 at 7:16
2
Solved
It may be very simple scenario for experienced developers, but as a beginner I have been hanging around this for a long time. I am creating a website in asp.net where a user can purchase a packages...
Halves asked 23/8, 2012 at 12:14
5
Solved
I have a 2008 SQL Server Express installed on one of my machines and I'm attempting to establish a remote connection... when I use the MS SQL Server Management Studio I can log into the database wi...
Mcmorris asked 15/6, 2009 at 16:52
5
I tried to set-up the SQL tables for ASP .net 2.0 membership provider by clicking on ASP.net Configuration under Project.
I have completely uninstalled SQL 2005 Express and installed SQL 2008 Expr...
Sutphin asked 19/4, 2009 at 10:3
3
Solved
I have two tables, Books and Authors, with many-to-many relationship between them through a third table called book_authors, i am trying to list all the books with the authors for each book using a...
Fernanda asked 11/5, 2012 at 12:17
5
Solved
I am using SQL Server 2008 express and i want to import .mdf and i get this error:
.mdf version is 661, your db supports the version 655
Which version is 661 and how to import it in sql Server 200...
Arel asked 17/3, 2010 at 14:17
2
I'm using SQL Server 2008 Express Edition.
I wanna create a sequence with this code:
CREATE SEQUENCE Postoffice_seq
AS bigint
START WITH 1
INCREMENT BY 1
MINVALUE 0
NO MAXVALUE;
and the er...
Scag asked 3/11, 2011 at 17:41
5
Solved
I have upgraded from Fluent Nhibernate 1.0 with Nhibernate 2.1 to pre-
release 1.x with NHibernate 3.0 GA and have hit what I think is a regression, but I want to hear if that's indeed the case.
...
Dorena asked 3/1, 2011 at 11:52
1
I am using SQL Server 2008 Express edition.
I have created a Login , User, Role and Schema.
I have mapped the user to the login, and assigned the role to the user.
The schema contains a number of...
Kimberleykimberli asked 13/12, 2010 at 12:5
1
Solved
I have tried to remotely connect to SQL. I put in port 1433, I restarted the service, and I don't have Windows' firewall active. However, I can only use local connection, I can't remotely connect. ...
Sparker asked 26/4, 2011 at 21:5
1
Solved
Hey, i need to export a query result to a CSV, but i get a semi-colon as a delimiter.
I went to:
Tools - Options - Query Results - SQL Server - Results to Text
and set
Output format: Custom ...
Boob asked 10/1, 2011 at 22:18
1 Next >
© 2022 - 2024 — McMap. All rights reserved.