Use this tag for questions specific to scaled down, free edition of SQL Server 2005.
Questions tagged [sql-server-2005-express]
193 questions
1
vote
3 answers
Why does this stored procedure execute quickly in Management Studio, but not in an application?
I have this query as a stored procedure:
SELECT ID
FROM dbo.tblRentalUnit
WHERE (NOT EXISTS
(SELECT 1 AS Expr1
FROM dbo.tblTenant
WHERE (dbo.tblRentalUnit.ID = UnitID)))
In Microsoft…
Malfist
- 31,179
- 61
- 182
- 269
1
vote
1 answer
windows 7, php 5.3, when fetching binary data with sqlsrv from mssql the data is doubled
ok, so I have images on a MSSQL 2005 (express) server which I want to write to files.
with the same piece of code, on linux it works fine, on windows it writes the data twice in the file
file_put_contents($file, $val);
$val = basename($file);
I…
dimvic
- 215
- 1
- 8
1
vote
5 answers
T-SQL - Error on Case Statement
USE NORTHWIND;
GO
SELECT SHIPCOUNTRY,[ORDERS_ID] =
CASE ORDERID
WHEN ORDERID = 10300
THEN 'I AM FROM 10300'
WHEN ORDERID = 10400
THEN 'I AM FROM 10400'
WHEN ORDERID = 10500
THEN 'I AM FROM 10500'
ELSE 'I AM OUT OF RANGE'
END
FROM ORDERS;
GO
Error…
mark
- 71
- 3
1
vote
1 answer
Adding a database to my Visual Studio 2008 project says I need sql server express?
When I try to add a new Sql Server Database file to my Visual Studio project, it tells me that I need to have Sql Server 2005 Express installed even though I have Sql Server 2005 Developer already? Is this by design and if so, why did Microsoft do…
Xaisoft
- 45,655
- 87
- 279
- 432
1
vote
0 answers
Create and Attach Database in SQL Server 2005 Express
I want to dynamically (through code at run time) find a SQL Server instance installed on the target PC, then create a database and finally attach my MDF file.
Is it Possible? How can I do that? (I'm using C# Framework 3.5 Visual Studio 2008)
Shahrokh
- 79
- 1
- 2
- 6
1
vote
3 answers
SQL Server: Could not find prepared statement with handle x
Recently our QA team reported a very interesting bug in one of our applications. Our application is a C# .Net 3.5 SP1 based application interacting with a SQL Server 2005 Express Edition database.
By design the application is developed to detect…
Bathiya Priyadarshana
- 1,325
- 6
- 22
- 35
1
vote
2 answers
Find out which website page are connected to SQL databases or instances
Is there a way to find out which parts of my different websites are connected to which SQL databases and/or tables? (database and websites were not built by me)
I want to know that page "whatever.aspx" is connected to the SQL instance…
Mr_Thomas
- 857
- 3
- 19
- 39
1
vote
2 answers
'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'
I want to use profiles and was able to use aspent_regsql -A p to install the tables. I can see them throughout SQL management studio.
I'm actually using SQLExpress 2005, and my dbo.aspnet_SchemaVersions is populated. Does anybody know what could be…
None
1
vote
1 answer
Why is the "enter or Select a database" dropdown list blank in the "Add Connection" wizard for visual web developer?
Why is the "Select or enter a database name" drop down list blank when I try to add a connection to my SQL Server Express edition using visual web developer 2008, using the "Add Connction" wizard and type "Sql Server". I can type a name in if I…
beauk
- 178
- 3
- 16
1
vote
3 answers
Is there a simple tool for adding users to a SQL Server database?
I'm looking for a simple tool, preferably one that I can redistribute with my application, that non-technical end-users can use to add users (and logins if necessary) to a particular SQL Server (Express) database.
Obviously SSME will do the job,…
Samuel Jack
- 32,712
- 16
- 118
- 155
1
vote
1 answer
Large .sql files
Not sure if this really belongs here, so please move it if it doesn't.
I have several very large .sql file that I'm trying to run in SQL Server Studio Express 2005. The problem is that when I try execute, the program says that I don't have enough…
Andrew
- 2,519
- 6
- 29
- 46
1
vote
2 answers
How to get CREATE TABLE Permission for windows authentication users in SQL Server express 2005
I recently installed SQL Server 2005 Management Studio Express. When I login to the Database server machinename\SQLEXPRESS using Windows Authentication.
I am unable to create tables or create databases. How do I grant the permissions for the users…
Nisha_Roy
- 424
- 2
- 9
- 15
1
vote
3 answers
Classic ASP and SQL Server Express 2005
Below is my simple asp code that I am using to insert some data to the SQL Server database. It gives the below error. Could someone please have a look and let me know the error with this code?
Address Book…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/c#" class="post-tag grid--cell" title="show questions tagged 'c#'" rel="tag">c#</a>
<a href="../../questions/tagged/sql-server" class="post-tag grid--cell" title="show questions tagged 'sql-server'" rel="tag">sql-server</a>
<a href="../../questions/tagged/asp-classic" class="post-tag grid--cell" title="show questions tagged 'asp-classic'" rel="tag">asp-classic</a>
<a href="../../questions/tagged/sql-server-2005-express" class="post-tag grid--cell" title="show questions tagged 'sql-server-2005-express'" rel="tag">sql-server-2005-express</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Apr 24 '11 at 09:06">asked Apr 24 '11 at 09:06</time>
<a href="../../users/591656/charithj" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/591656.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="CharithJ" />
</a>
<div class="s-user-card--info">
<a href="../../users/591656/charithj" class="s-user-card--link">CharithJ</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">46,289</li>
<li class="s-award-bling s-award-bling__gold" title="20 gold badges">20</li>
<li class="s-award-bling s-award-bling__silver" title="116 silver badges">116</li>
<li class="s-award-bling s-award-bling__bronze" title="131 bronze badges">131</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-565361">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>1</strong></span>
<div class="viewcount">vote</div>
</div>
</div>
<div class="status ">
<strong>7</strong> answers
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/565361/continuous-database-backups" class="question-hyperlink">Continuous database backups?</a></h3>
<div class="excerpt">I have the following scenario:
Our system is running a SQL Server Express 2005 database locally (on each users desktop, if you will). The system is storing a lot of production data from a machine. There are high demands on the safety of the data,…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/database" class="post-tag grid--cell" title="show questions tagged 'database'" rel="tag">database</a>
<a href="../../questions/tagged/sql-server-2005-express" class="post-tag grid--cell" title="show questions tagged 'sql-server-2005-express'" rel="tag">sql-server-2005-express</a>
<a href="../../questions/tagged/backup-strategies" class="post-tag grid--cell" title="show questions tagged 'backup-strategies'" rel="tag">backup-strategies</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Feb 19 '09 at 13:44">asked Feb 19 '09 at 13:44</time>
<a href="../../users/30388/tmatuschek" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/30388.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="tmatuschek" />
</a>
<div class="s-user-card--info">
<a href="../../users/30388/tmatuschek" class="s-user-card--link">tmatuschek</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">608</li>
<li class="s-award-bling s-award-bling__silver" title="4 silver badges">4</li>
<li class="s-award-bling s-award-bling__bronze" title="15 bronze badges">15</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-5125339">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>1</strong></span>
<div class="viewcount">vote</div>
</div>
</div>
<div class="status answered-accepted">
<strong>1</strong> answer
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/5125339/using-logins-users-permissions-in-sql-server-2005-express" class="question-hyperlink">Using logins, users, permissions in SQL Server 2005 Express</a></h3>
<div class="excerpt">I connected to SQL Server with Windows Authentication (Admin).
Then, I created a login for my SQL Server 2005 Express as:
CREATE LOGIN bob WITH PASSWORD = 'bobpass'.
Now, I closed SQL Server & then again opened it & this time I connected it with…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/sql" class="post-tag grid--cell" title="show questions tagged 'sql'" rel="tag">sql</a>
<a href="../../questions/tagged/authentication" class="post-tag grid--cell" title="show questions tagged 'authentication'" rel="tag">authentication</a>
<a href="../../questions/tagged/sql-server-2005-express" class="post-tag grid--cell" title="show questions tagged 'sql-server-2005-express'" rel="tag">sql-server-2005-express</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Feb 26 '11 at 05:51">asked Feb 26 '11 at 05:51</time>
<a href="../../users/613929/sqlchild" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/613929.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="sqlchild" />
</a>
<div class="s-user-card--info">
<a href="../../users/613929/sqlchild" class="s-user-card--link">sqlchild</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">8,754</li>
<li class="s-award-bling s-award-bling__gold" title="28 gold badges">28</li>
<li class="s-award-bling s-award-bling__silver" title="105 silver badges">105</li>
<li class="s-award-bling s-award-bling__bronze" title="167 bronze badges">167</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="s-pagination pager fr">
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=3" rel="prev" title="Go to page 3">Prev </a>
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=1" rel="" title="Go to page 1">1</a>
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=2" rel="" title="Go to page 2">2</a>
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=3" rel="" title="Go to page 3">3</a>
<div class="s-pagination--item s-pagination--item__clear">…</div>
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=12" rel="" title="Go to page 12">12</a>
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=13" rel="" title="Go to page 13">13</a>
<a class="s-pagination--item" href="../../questions/tagged/sql-server-2005-express_page=5" rel="next" title="Go to page 5"> Next</a>
</div>
</div>
</div>
</div>
</div>
<script src="../../static/js/stack-icons.js"></script>
<script src="../../static/js/fromnow.js"></script>
</body>
</html>