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
2 answers
sql query to get the column value again in case statement
select *,
case when number = '12' and status = 'y' then cost
end as [price]
from tblx
i got the results from the above query, i want to use the value of price column, again in case statement of the same query as like below
select *,
case when…
Kumar
- 11
- 7
0
votes
1 answer
Error opening .mdf file through SQL Server Management Studio Express
I am doing a project of a web enabled database. I have created the database file in my PC.
Now when I just want to open .mdf i.e. of the database I created, I cannot open it in other PC. I even had copied the .ldf file i.e the log file to that…
Nagaraj Tantri
- 5,172
- 12
- 54
- 78
0
votes
3 answers
Visual Studio 2005 SQL Server Express edition username pass
Visual Studio 2005 I connect with SQL Server Express edition with SQL Server Management Studio Express using Windows authentication.
When I installed Visual Studio 2005 I didn't get asked for SQL Server Express edition user name or password. How can…
d-man
- 57,473
- 85
- 212
- 296
0
votes
2 answers
SQL Server 2005 Express - could not open a connection
I installed Microsoft SQL Server 2005 Express edition on my Vista Ultimate computer. However, when it opens I enter my computer name / SQLEXPRESS. When I click the Connect button, it gives me an error message.
Under the configuration tools I cannot…
Yoosuf
- 882
- 7
- 33
- 52
0
votes
1 answer
Replication SQL SERVER
In my Production Server i have replication which working fine, i do have Distributed Database which as 2 subscriber db .
My data is replicated from Production envi (working fine) but while
data gets replicated to Distributed database in Subscriber…
Dhiva
- 221
- 1
- 4
- 6
0
votes
2 answers
Problems with SQL Server Express user instancing and ASP.net Web Application Projects(dotnet nuke)
I am trying to connect to SQL Express 2005 through DotnetNuke. My OS is windows 7(IIS 7) and when i tried to connect i got the following error:
An attempt to attach an auto-named
database for file (file
location).../Database.mdf failed. A
…
Harun
- 5,109
- 4
- 38
- 60
0
votes
1 answer
SQL Server Express Idle Mode Partial Data Returns?
I'm attempting to help our network engineers troubleshoot a situation for one of our clients. This client purchased a point-of-sale system from quite literally a "mom-and-pop" vendor, and said vendor recommended SQL Server Express 2005 as the…
John Rudy
- 37,282
- 14
- 64
- 100
0
votes
2 answers
How to connect VB.net to SQL Server 2005 Express using Windows Authentication?
Public DbCon = "Data Source="";User ID="";Password="";Initial Catalog="";"
So far this is the code for SQL Server Authentication that I know.
I want to know the connection string for Windows Authentication
Harmonix
- 3
- 3
0
votes
3 answers
enable TCP in SQL server 2005 express edition
sorry for answer but how to enable TCP in SQL server 2005 express edition? I used configuration manager, find network configuration/protocols and there enabled TCP, after that I have restarted sql server service and tried installation of problematic…
david
- 1
- 1
- 1
0
votes
2 answers
Rename SQL Server 2005 Row Values
I want to rename several values on my table.
I just want to rename multi rows in a column of a table in my database :
SJ.10.06.000001
SJ.10.06.000002
SJ.10.06.000003
SA.10.06.000001
SB.10.06.000002
etc into this value…
Danang Wahyu
- 13
- 1
0
votes
1 answer
A SQL Server 2005 Express query that will add a table per database
Here is the query that I am trying to run
DECLARE @str VARCHAR(10)
DECLARE @index int
DECLARE @SQL VARCHAR(100)
DECLARE @SQL2 VARCHAR(300)
DECLARE @SQL3 VARCHAR(400)
SET @str = 'DB'
SET @index = 0
WHILE @index < 100
BEGIN
SET @SQL = 'use ' +…
ALupus
- 3
- 1
0
votes
1 answer
vb 6 showing timeout expired while executing stored procedure
when i tried to execute this stored procedure it is giving me timeout expired error here is my stored procedure
ALTER procedure [dbo].[sp_rptExpMed]
(
@Stocname as varchar(100),
@date varchar(40),
@Mode int
)
as
begin
if @Mode=1
begin
…
Sony
- 7,136
- 5
- 45
- 68
0
votes
1 answer
SQL Select When
I need to find out the final profit based on the fact that some items have discount, but the discount is set between a date interval and only then is applied on a set of items.
What's wrong here?
use Companie
select…
Andrei-Paul
- 1
- 4
0
votes
1 answer
MS SQL SERVER 2005 express - Can't find import/export wizard
I have installed ms sql 2005 express i have installed the management studio, i tried(all components already installed) to install the ms sql 2005 express toolkit.
I've searched for the .exe and for the option inside the management studio, and i…
user3751397
- 1
- 1
0
votes
1 answer
Invert a decimal into a query
I have a column that is currency displayed as a numeric field. So, '$3.15' is recorded as '315'. When doing my query, I'm looking to place a decimal two places into these numbers so that 2066 becomes 20.66 and 315 becomes 3.15
I know it's most…
Anthony Morack
- 29
- 2
- 6