sql-server-express

What profiler to use with sql express?

is there a way to monitor detail of sql calls in express version? ...

Can SQL Express Reporting Services generate Word documents from RDL

I know I can generate PDF reports with SQL Reporting Service (even SQL Express can do this) and I can do Word documents with SQL Developer edition. Since my dev box is SQL Developer and my website uses SQL Express (I know, it's far from ideal) I would like to know if the reporting service that is included with SQL Express can generate Wo...

SQL Server Ports

We recently installed a sonic firewall on our network. We have a SQL 2005 express server that's configured to listen on dynamic ports. In its configuration manager the dynamic port number is set as 1067 with its default port still 1433. From my understanding we need to have the following ports open for it to work: Tcp 1433 Tcp ...

How can I do a BEFORE UPDATED trigger with sql server?

I'm using Sqlserver express and I can't do before updated trigger. There's a other way to do that? ...

SQl Server User Instance in Console Application

Is it possible to user SQL Server Express User Instance databases with Console applications or do they only work in Web projects? ...

Any good SQL Server Management software for Mac OS?

I am used to using SQL Management Studio Express on Windows and was wondering if there were any good ones with similar functionality and price (free) for Mac OS X. ...

Sql server 2005 torn page,error 424

Hi all, My Dell pc failed;it was blue screen.I fixed that problem by formatting and reinstalling OS and other software that i have been using.Then I recoved my db designed using sqlserver 2005 and other files using recovery tools ;Easy Recovery 6.0. The problem is : When I try to attach the recovered file(lpdb.mdf),It can not attached.T...

SQL Express User Instance with multiple ASP.NET Sites

How can I get two separate ASP.NET sites, in this case a Web Site using Entity Framework and Web Service, to use the same local database mdf & ldf? I looked around and I think that this kind of local DB is called a User Instance - at least they way I'm currently using it. I wasn't sure if it would work or not until I found the below in...

How to Export SSIS data on SQL Standard and Import with Bulk Insert on SQL Express?

I would like to use SSIS to create database table flat file exports then import them in to variously distributed SQL Express installs. As you may guess, SSIS is not available in the Express version. When I do the bulk insert, it errors with: Msg 4866, Level 16, State 8, Line 1 The bulk load failed. The column is too long in the data f...

Default values from SQL Server Express table column to Dataset?

Hi, I am a new Database programming learner. I am using C# (.NET 3.5) along with SQL Server Express. I am following Forms over Data Video Series from Microsoft. However, I am creating a databse, different from the one created in the videos. In one of the tables, I wanted the present date/time to be inserted in the date column, so I am...

Problem connecting VWD Express 2008 to SQL Server Express 2005

Hi, WHen i try to connect to SQL Express 2005 from Visual Web Developer Express 2008, i was getting errors like 'Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc' . I read some posts which advised me to download and install 3 applications to address above issue ( SharedManagementObjects.msi, sqlncli.msi,SQLSysClr...

SQL Managment Studio Express - Project and Solutions

I have SQL Managment Studio Express, but notice it doesnt have the add on for solution and project creation. Is there a download to add that functionality so I can group my queries and connections? Or is this funcationality not available for express? ...

is there a sql server profiler for sql express

is there a sql server profiler for MSsql expess ? maybe an open source one ? or maybe just a tool that helps me see what query is passed to the database ? ...

How can I keep my SQL Server Express connection from timing out the first time through testing?

We have some automated tests for the interaction between our data access layer (C#) and the database (MS SQL). We are using SQL Express to mount an mdf, which we revert after the testing is done. It seems that the first time the tests are run on a freshly booted machine, we see timeouts, even though SQLExpress is running. The second t...

Is there a standard way to deploy an application with SQL Server express?

In Winforms or WPF Is there a standard way to deploy an application with SQL Server express? Is there a standard way to create a local SQL Server express database and also update the app.config connectionStrings settings during an application install? ...

Can I install 2008 SQLExpress alongside 2005 SQLExpress?

Can I have an instance of 2005 SQLExpress and a 2008 SQLExpress server running on my machine? Both to be accessed using the 2008 management console. I currently have the express tools installed, but my office recently purchased a full 2008 license. Does this come with an improved console? And if so, can I just install these tools or ...

ASP.NET SQL Server Setup Wizard

I have a asp.net web project I am working on, and found out my roles and such are stored in an .mdf file. While reading on attempting to connect to it via SQL Management Studio (using SQLExpress 2005), I found this article: https://help.maximumasp.com/SmarterTicket/Customer/KBArticle.aspx?articleid=878 Now, my question is - should I b...

Mirroring-like functionality in SQL Express via replication?!

We have 2 SQL Express (2005) servers. As you probably know, database mirroring is not enabled in the Express editions, but replication is. Would it be possible to enable replication between both servers to have some kind of mirroring-like functionality?! What would be the possible drawbacks if it is possible at all? ...

Castle Active Record: SQL Express doesn't work. SQL Developer does.

I've been trying to troubleshoot a Castle ActiveRecord exception for days now. Whenever I attempt to access the database I get an exception with an InnerException value of "An attempt to attach an auto-named database for file database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located o...

What free admin tools are available for SQL Server Express 2005?

I am developing in visual studio 2008 (new) and it would be convenient to to have an Enterprise Manager / SQL Server Development Studio like tool to manage the databases. I am wonder what other developers who don't have acccess to SSDS are using. ...