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

Migrate Sharepoint 2007 and database from two separate servers to one physical server

I'm looking for any advice on the best way to migrate a SharePoint 2007 installation and a database. The current setup is a server running SharePoint 2007 with the database stored on a separate SQL Server installation. Due to performance issues we…
user2515514
  • 1
  • 1
0
votes
1 answer

Copying/creating .mdf files in SQL Server folder during setup of C# windows application

Is it possible to copy my database files i.e .mdf files to a destination folder which is my SQL Server folder during setup of my windows C# application? Also, how do I attach those filed to the database of sql server automatically in setup?
user2274463
  • 9
  • 1
  • 7
0
votes
2 answers

Installing SQL server 2005 through windows c# setup project

I have a windows c# application with its setup file. Now I wish to install SQL Server 2005 express edition while the setup of my application is being installed on any computer. Is this possible ? How ?
user2274463
  • 9
  • 1
  • 7
0
votes
1 answer

Datagridview data binding from database error

I have a datagridview in my Windows C# application. I am binding some data from my SQL server 2005 database into it. The datagridview already has a fixed number of columns and rows with their indivdual names. The problem is the data is displayed…
Sudeep Purohit
  • 21
  • 1
  • 3
  • 7
0
votes
1 answer

SQL Server 2005 Express : Group By

A distributor have various outlets to sale products. Products are based on categories. Outlets can receive products from the distributors and from other outlets (transfers). Opening balance (Qty), receipt (Qty), transfer IN (Qty), transfer Out…
Dhruv Ganesh
  • 23
  • 4
0
votes
0 answers

Error while connecting to a SQL Server Database: not trusted connection

We have installed on a company a SQL Server 2005 express on a server. Some workstations connects to the server while they're using our applications with Windows Authentication. But there's ONE computer that can't connect. When the user opens any…
davidrgh
  • 853
  • 2
  • 10
  • 17
0
votes
3 answers

Automatically backup SQL Server database

I need to backup SQL Server database. Is it possible to do this automatically without human intervention at regular intervals? If so yes then please suggest me how to do it and I'm using SQL Server 2005 Express Edition.
Fairy_G
  • 407
  • 3
  • 12
  • 23
0
votes
2 answers

How to calculate with sql queries or views

I have a table id name parentid ---------------- 1 a 0 2 b 1 3 c 2 4 d 1 Now I want to calculate level with if direct parent id count = 6 then level1, if have 6 level1 count then level2, if have 6 level2 count then level3,…
Rohan
  • 157
  • 1
  • 15
0
votes
2 answers

Export SQL database (all tables) from remote server

I'm current using a 3rd party product, which uses an SQL Server database. I've been asked to take a copy of the database for our own backup/security purposes, but I'm having trouble. To access the database I'm currently logging into one of my…
QMKevin
  • 1,101
  • 3
  • 13
  • 26
0
votes
3 answers

T-SQL Remove Time From DateTime

What is the difference between these 2 lines in SQL Server 2005 Express? DATEADD(d, 0, DATEDIFF(d, 0, @Today)); and DATEADD(d, DATEDIFF(d, 0, @Today), 0); Other than making this statement fail at random times: DECLARE @DateSrc DATETIME; -- Chop…
Cheval
  • 403
  • 4
  • 14
0
votes
1 answer

Dynamic versus explicit querys in sql-server 2005

Can anybody explain this? Theoretically both are the same query but they give different answers. a) declare @date varchar(10) set date = '03/02/2013' select count(*) from table1 where (from <= @date) and (@date <= to) b) declare @date…
user2053679
  • 1
  • 1
0
votes
1 answer

Creating a custom installer for occasionally connected application using database of another software

I am trying to create an application which will synchronize its database with another software's database.. Problems are: How will the database will synchronize with external database after I have created the installer and installed..i.e. how will…
humorousdragon
  • 55
  • 2
  • 12
0
votes
1 answer

SQL Server File Attaching Issues

I am attaching DBs using SQL Server 2005 Express. Some files are attaching with path and some without it (see below) I am attaching them all from the same folder. Please advise what is the difference?
Furqan Sehgal
  • 4,917
  • 33
  • 108
  • 167
0
votes
4 answers

How to store Vietnamese characters in SQL Server 2005?

I wanted to add my colleague's information in my database for testing purposes. Since he his from Vietnam, his name has a special Vietnamese character in it ('ơ'). When I updated the database, the character was transformed to a regular 'o'... How…
Julien Poulin
  • 12,737
  • 10
  • 51
  • 76
0
votes
2 answers

Is NHibernate supported on SQL Server 2005 Express?

I want to use SQL Server 2005 Express as database. Will NHibernate be supported with it?
user1693564
  • 29
  • 2
1 2 3
…
12
13