Use this tag for questions specific to scaled down, free edition of SQL Server 2005.
Questions tagged [sql-server-2005-express]
193 questions
0
votes
0 answers
Is SQL Server 2012 express faster than SQL Server 2005 Express?
Recently, I upgraded my development computer to Windows 8 and now, I am having hard time installing SQL Server 2005 express on my development machine. My ASP.NET MVC Website project is based on SQL Server 2005 Express. (Entity Framework CodeFirst…
Emran Hussain
- 11,551
- 5
- 41
- 48
0
votes
2 answers
Not able to connect SQL Server 2005 Express using c# remotely
I am trying to connect to a SQL Server 2005 Express edition remotely using c#, but it is throwing an exception.
A network related or instance specific error occured while establishing a connection to SQL Server .The server was not found or was not…
Sohail
- 780
- 3
- 14
- 27
0
votes
3 answers
Query a datetime in SQL Server 2005 Express
How to query the rows based on DateTime in SQL Server 2005 Express installed on windows server 2008 r2?
I have code that selects rows based on from and to date values. It's working in my Windows 7 system . But, It's not working on Windows Server…
Ananthakumar Alwar
- 73
- 1
- 12
0
votes
3 answers
SQL Server 2005 Express cannot update datetime field when windows is set to Italian
I am struggling with an MS SQL 2005 Express issue. A query like the one below works perfect when Windows Regional Options (control panel) is set to English (United States), but it fails when set to Italian (and maybe other languages).
UPDATE MyTable…
Roy
- 318
- 3
- 8
0
votes
3 answers
Install SQL Server 2005 Standard on a computer with SQL Express
Folks,
Visual Studio installed SQL Server Express on my computer, which to date has satisfied my needs. I now need to do remote database support so need the full version of management studio. I tried to install the standard version but it is…
Seeking knowledge
-1
votes
2 answers
Convert /Attach SQL Server 2005 .mdf to 2008 .mdf?
I have SQL Server 2005 .mdf file and now I need to attached the same to SQL Server 2008
so how can I do the same.
Is any such tool is available , which convert 2005 .mdf file to 2008 .mdf file ?
As I do not have access to SQL Server 2005 at all .
BJ Patel
- 6,148
- 11
- 47
- 81
-1
votes
3 answers
SQL server column alias from another query
Why does this code not work in SQL Server 2005?
select c.price AS (select CityName from Cities ci where ci.cityid= c.cityid)
from prices c
where cityid=1
Thanks.
-1
votes
2 answers
Uninstalling SQL Server instance, I lost my user database
IT admin has uninstalled the test SQL Server instance. It had a huge real time test data.
I want to know if
Uninstalling an instance deletes the database?
Is there way to recover the lost database?
hrishi
- 1,531
- 8
- 28
- 43
-2
votes
2 answers
fetch score from previous rank belonging to another student
I'm trying to to fetch score from previous rank belonging to another student for every row in the following select statement. Now, I'd like to have the Score of previous Rank in each GroupCode for every CourseCode and StudentCode.
SELECT…
bahador arghavan
- 9
- 5
-2
votes
1 answer
This server supports version 611 and earlier. a downgrade path is not supported
Which SQL Server 2005 Express (means in which service packs) to be install to remove like
this server supports version 611 and earlier. a downgrade path is not supported
user2801432
- 23
- 1
- 6
- 13
-2
votes
1 answer
How to make a sql procedure?
Can you give me some tips of how and IF I can make some stored procedures out of this,please?
-- Declarare variabile
Declare @p1 float,@p2 float,@p3 float, @p4 float, @CostFix float,@CostVar float,@suma float;
select @p1=sum(Cantitate)from…
Andrei-Paul
- 1
- 4
-2
votes
3 answers
INSERT INTO fail
int dose = Convert.ToInt16(DoseTextBox.Text.ToString());
try
{
SqlCommand AddMed = new SqlCommand("INSERT INTO Medications VALUES(@Medication,@Dose,@manufacture)", mcs);
…
Ameer Adel
- 82
- 1
- 1
- 12
-3
votes
1 answer
how to resolve this error "Use of getPreventDefault() is deprecated. Use defaultPrevented instead."
I tried to fetch datas for a particualr user from sql sever database using json data. But its always showing error in the console as:
"Use of getPreventDefault() is deprecated. Use defaultPrevented
instead."
And values are not retrieving from…
MDP
- 17
- 1
- 7