Stack Overflow
Stack Overflow

Questions tagged [sql-server-2005-express]

Use this tag for questions specific to scaled down, free edition of SQL Server 2005.

193 questions
0
votes
1 answer

SQL Server Reporting Services Standard Edition report against SQL Server Express database

I want to know if SQL Server Reporting Services Standard Edition is capable of running a report against a SQL Server Express database. In addition if its possible to schedule reports against a SQL Server Express database.
AJM
  • 32,054
  • 48
  • 155
  • 243
0
votes
1 answer

timeout in sql server and attachment of db in sql express 2005?

Intro. i have made a application in vs 2008 using c# and at back end i am using sql express 2005. Application background: just like report tool in which user select some parameters and get results in cube after she can import that result into excel…
Haid
  • 111
  • 2
  • 10
0
votes
3 answers

SQL Server 2005 Express: back up to a folder on the network

I am using this code as a procedure on an application. At the mid-night, it will trigger the procedure. http://www.geekzilla.co.uk/View487F82A5-C96B-4660-A070-F7C8B7FC4431.htm I changed this locally back-up: TO DISK = N''c:\db backup\' to: TO …
olidev
  • 20,058
  • 51
  • 133
  • 197
0
votes
1 answer

any free SQL Server 2005 express database schema generation and reverse engineering tool?

thanks for your time and sharing. Please guide me is there some free tool (to use with SQL Server 2005 Express edition) that can generate data base schema by making diagrame and reverse engineering of an existing database ? Thanks for guiding me.
haansi
  • 5,470
  • 21
  • 63
  • 91
0
votes
2 answers

Upgrading SQL Server 2005 Express to Standard

I have a straightforward installation of SQL Server 2005 Express with a named instance (SENSE), and a single database (sense), on which I wish to perform an in-place upgrade to 2005 Standard Edition. Running without command line parameters results…
Adrian Hand
  • 480
  • 3
  • 8
  • 19
0
votes
3 answers

ASP.NET app wont share database with Sql Server Management Studio Express

I have an ASP.NET 3.5 app with a SQL 2005 Express .mdf database file in its App_Data folder. Lets call that Foo.mdf. On its own the ASP.NET app can connect to the database with no problems. So far so good. Then, if I install Sql Server Management…
codeulike
  • 22,514
  • 29
  • 120
  • 167
0
votes
2 answers

Is SQL Studio part of SQL Server Express edition?

Is SQL Studio part of SQL Server 2005 Express edition? If not, how do you restore a database to the server if there is no Studio to use?
Craig Johnston
  • 5,303
  • 8
  • 27
  • 30
0
votes
2 answers

How do I retrieve data from SQL server table which has two columns say PatientID and TestNo, Differnt TestNo can have same patient ID

I have a database (SQL server 2005 Express) table wth columns PatientID (more than 1 records can have same patient ID) and TestNo. I want to retrieve the maximum of testNo column among all the records with same PatientID.What should be the SQL…
FerozKhan
  • 11
  • 2
0
votes
2 answers

create database in sql server 2005 express edition without Browser

I have an SQL server Express edition Instance and I need to create a database on it but I don't have the Sql Browser how can I do it other wise
Mario
  • 167
  • 1
  • 6
  • 17
0
votes
2 answers

Upgrading SQL Server 2005 Express to SP3

I'm trying to install SQL Server 2005 Express SP3 on two of my machines. When I try to do this I get this error message: "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the…
pbz
  • 8,865
  • 14
  • 56
  • 70
0
votes
6 answers

How to get alone time 11:21 (highlighted in red) with SQL Server database?

Done automatically add the date to the time of the database SQL Server 2005 Express. So when you add a new record in the database is added automatically date and time in the form of: Create Table Baza_test ( ID bigint IDENTITY (1,1) NOT NULL, …
darjab
  • 129
  • 1
  • 8
0
votes
1 answer

Accessing SQL Server Express 2005 database via 2008 64bit SSMS

I have a 64bit Vista laptop. Initally, I tried to Install a 64bit version SQL Server Express 2005 on my computer, but no matter what I tried, only the 32bit version seemed to work...so that is what got installed. The 32bit SQL Server Express 2005…
Clinemi
  • 906
  • 6
  • 20
  • 33
0
votes
1 answer

Problems converting NVARCHAR to INTEGER in SQL Server 2005 Express

Afternoon everyone, I'm having some issues converting a calculation into a INTEGER! Essentially I have the calculation; CAST(ROUND(SQRT(SQUARE(69.1*(CAST(tblPostCode.PCLat AS DECIMAL(30,15)) - "& 53.078282 &")) + SQUARE(69.1 *…
Pete Wilson
  • 1
  • 1
0
votes
1 answer

My application cannot connect with my database on MsSql express 2005

I have an windows desktop application which uses Mssql2005 express database. But sometimes, my application cannot connect with the database. When I run "exec sp_helpdb", my database name is not included in the result list. And when I try to attach…
Orgil
  • 187
  • 3
  • 13
0
votes
1 answer

Cascade tree deleting in MS SQL Server Express 2005

One table has the name "Stages", every Stage can have 0 to infinity children. In the table "Stages" there is a column named "Parent". This column is foreign a key for the same table "Stages". How would I make a cascading delete for this tree? I…
Dmitriy Kudinov
  • 1,051
  • 5
  • 23
  • 31
1 2 3
…
12 13