sql-server-express

SqlServer 08: Query to list all databases in an instance?

How do I list all the databases for a given sql server 08 instance using sqlcmd? ...

Visual Web Dev 2008 & SQL Server Express 2008; not working together?

So....I am a rookie at this so if I missed something simple, please excuse me, but I don't know. So i downloaded Visual Web Developer 2008, SQL Server Express 2008, etc, and I am trying to learn how to use SQL Server, and create .aspx web pages, etc. So one of the first things I tried was the Hello world (C#) ine Web Dev and it worked ...

Remote login to SQL Server Express 2008

Hey. I am remotely accessing SQL Server Express 2008. I have turned on service "SQL Server Browser" I have turned on service "SQL Server (SQLExpress)" I have enabled TCP/IP and set dynamic ports to blank and tcp port to 1433 in properties I can connect localy(using ip) so my credentials are correct. I have a exceptions record in my wi...

SQL Server 2005 express connection with Visual Web Developer 2008 express.

Ok so I had first downloaded SQL Server Express 2008 and Wed Developer Express 2008, and I could not integrate the two together. Was getting error messages that were wasking for the correct version of SQL Server 2005, so.... I uninstalled SQL Server Express 2008, and installed SQL Server Express 2005. Now I open the Visual Web Develope...

Problem attaching to a sql server express db file using network service account

I am using VS2010 Beta 2 to create an IIS hosted WCF service. I added a SQL Server database file to use as a simple data store and then generated some Linq to SQL classes to interact with it. The problem I have happens when Linq to SQL tries to connect to the database. I get the following error below: CREATE DATABASE permission denied ...

How to query from log files (.ldf) of Sql Server 2005 Express edition?

I want to do this, because I would like to know how many times a particular row has been changed. Is this possible? Thanks ...

Web Platform installer and sql express database setup

I tried to install Amplifeeder today with the Web Platform Installer. When I arrived at the database setup I had to fill out some informations like "db admin user/password" and user username/password. Using SQL Express I do not have any username/password (neither admin or user). How should I be able to install applications with the WPI...

SQL Server 2008 Express SSRS: export to CSV

Do Reporting Services in SQL Server 2008 support export to CSV? I only see Excel/Word/PDF in the dropdown list on in the SSRS localhost server when previewing report. I found in internet that SSRS 2008 seems to support CSV but I don't see it; is it Express limitation? I haven't found any notes about this limitation. ...

Select * into SqlserverTable2 from SqlExpressTable1, can this be done

Can I Select * into a Sqlserver Table from a SqlExpress Table the way I can from a Sqlserver Table to a Sqlserver Table using Select * into Table2 from Table1 If so, what is the syntax? ...

lost my ASPNETDB.mdf

I am working on the MVC storefront Rob Conery project and I lost my ASPNET.mdf database ! I would like to have the ASPNET.mdf database in my App_Data folder. I tried to include the db right clicking on it and including it in the project. But on the Server Exporer when I am tring to look at tables there are none. Here is my Web.Config f...

Recommended SQL database for commerical product

We have a commercial off the shelf product which used a Access Database. Due to the limitations and corruptions involved in multi user environments we decided to move to SQL Express. However now asit turns our,deployment of SQL Express 2005/2008 is a nightmare. The list of dependencies these depend on just keeps growing. Can anyone recom...

Reporting Services running on SQL Server 2008 Express

I know I can run Reporting Services on SQL Server Express w/ Advanced Services. The articles I have read do not touch on my question. I'm wondering, in this scenario, can remote users execute reports from the report server remotely using URL access ex:)http://mySQLExpressBox/ReportServer/rptMyReport....... etc - Or will reports only...

Database Create on SQL Server2008 Express/Windows VIsta Home Edition

I successfully installed Express on Windows Vista Home Edition. When I tried to create a database using the account under which it was installed I received this message: TITLE: Microsoft SQL Server Management Studio Create failed for Database 'Test1'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while exe...

Migrating an ASP.Net-MVC Application to a New Server

So basically, I developed this ASP.Net MVC application on a Windows 7 box with Visual Studio 2008. It works well on the local machine, and I was able to host it in IIS no worries. I then decided to upload it onto subversion, and fetch it on a different Windows Server 2008 machine. I downloaded it, had the IIS document root point to my ap...

Install sql express 2005 and backup database on application install

Hi I have a c# wpf application that requires SQL Express 2005 database and I want to deploy Sql Express with my application. So I googled but didn't find any valuable information how to create an installer that will 1. install Sql Express 2005 and 2. restore my backup database before my project installetion? I have tried to inst...

Can't connect to SQL Server Express anymore

I think I made a mistake and I lost my connection to my SQL Server Express. In SQL Server Management Studio under security I disabled the login option. Now when I try to connect to the Server I get the message : "Cannot connect to HP16969\SQLEXPRESS". Additional informations : Login failed for user 'HP16969\Bernard (Microsoft...

Is IF Executed either way?!!!

I am getting errors executing the following statement: /* AccountTypes Constraints */ IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountTypes]') AND type in (N'U')) BEGIN PRINT 'Table [AccountTypes] exist.' IF NOT EXISTS(SELECT 1 FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Accoun...

SQL Server Express - Website not working

I have a new website that I'm trying to deploy. It works great on my local machine, but when I install on the server, it no longer works and I don't get any error messages. I'm using SQL Server Express, but this isn't installed on the server. Do I need to do this? ...

SQL to skip running Create Partition Function under SQL Server Express

Our database schema is stored in a single file that is intended for production use but we also use when running functional tests on our local boxes. We drop the database and rebuild it from this file and then add a known set of test data. All was working well. Recently we added some performance improvements. The trouble came when we ...

SQL Express Edition, SQL Compact Editin and SQLCMD for learning purpose

Hi, I want to learn programming in SQL from some SQL tutorial sites of which I heard of here but I need some environment for executing query's. I think I have both SQL CE and SQL EE installed on my computer but I have some doubts about these DBMS and I don't know exactly how to use SQLCMD utility so I hope someone here will have time an...