Create new SQL 2008 database in external drive
My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.

Answer Question   |  March 31, 2012  4:00 PM
External Disk Drives, SQL Database, SQL Express, SQL Express 2008

Name Pipe work arounds in SQL 2005 database
I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue [...]

Answer Question   |  March 31, 2012  12:41 AM
SQL 2005, SQL Express, SQL Server, SQL Server administration, SQL Server security

Empty reports in TMG2010
I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was “The report server cannot process the report. The data source connection…

Answer Question   |  June 6, 2011  5:15 AM
Forefront TMG 2010, Report Server, SQL Express, SQL Server Report Server, WAIK for Windows 7, Windows Server 2008 R2

Microsoft Retail Management System and SQL Server “Write” error
I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform.  Store Operations Administrator and Manager are working with no problems.  I know I am networked properly.  When I open the POS I get the following:  “Open-Incorrect Function”, I can click OK and sign on the the POS, then I get “Write-No [...]

Answer Question   |  August 18, 2010  5:03 PM
Microsoft Retail Management, RMS, SQL Express, SQL Server 2005, SQL Server 2005 error messages, SQL Server error messages, Windows XP

Read Excel from Sql Server 2005/2008 SQLEXPRESS
How to read the excel data’s from Sql Server 2005/2008 SQLEXPRESS

Answer Question   |  July 20, 2010  11:30 AM
SQL Express, SQL Server 2005, SQL Server 2008, SQLEXPR

SQL Query for Price Data of Different Stocks from 1 table with same dates
I am having 1 table with date, stock and price data for all stocks. I want a sql query which will display the date, stockname1, stockname2, stockprice1 and stockprice2 for the 2 stocks I mention and the date range I mention and date should be common to both stocks. If stock1 has a price on [...]

Answer Question   |  June 17, 2010  7:58 AM
SQL Express, SQL Express 2005, SQL Query, SQL Server

Selecting Reporting Builder 3.0 on the Report Manager Site
Can Report Builder 3 be added as a selectable tool on the Report Manager site created by a SQL Express with advanced features installation? Does the license allow using RB3 and is there documentation on how to get it to show up at the top of the report manager site?

Answer Question   |  May 3, 2010  9:58 PM
Report Builder 3.0, SQL Express, SQL Server 2008 R2

SQl Server 2008 R2 features in SQL Express
If I go to the SQL Express download site and install SQL Express with advanced features will it include any R2 features and if so where can I find a list of differences between the Express I installed 3 months ago and what I can install now?

Answer Question   |  May 4, 2010  9:46 PM
SQL Express, SQL Server 2008 R2, SQL Server 2008 R2 Features

How to use Insert command between two servers to speed up performance
We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the [...]

Answer Question   |  April 19, 2010  4:34 PM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance

sql data conversion error 91Object variable or with block variable not setExecuting sql
Error 91 Description: Object variable or with block variable not setExecuting sql statementRetrieving division information from the sql data store. Checking for the core database. Source: AFWSvDataServices3Converter.ConvertergetSQLDivisions, converter.convertergetdivisions, converter.convertergetDatabaseSTatii, converter.converter.Initialize, converter.converterStartIIconverter.converterStartCommandLine.

Answer Question   |  January 25, 2010  3:40 PM
SQL error messages, SQL Express, SQL Express 2005

SQL Server Express 2005 Installation Failure
Here is a fix for SQL Server Installtion failure. And a fix for newly installed programs that cause memory faults. I encountered an issue after installing SQL Server Express 2005. Where I get a blue screen with c000021 0xc0000005 this is an install on a Dell PowerEdge 600SC Widows XP SP2. To correct the problem, [...]

Answer Question   |  December 23, 2009  7:07 PM
0xc0000005, SQL Express, SQL Server 2005, XP

How can one ‘v-app’ an application that uses a db like SQL 2008 express?
How can one ‘v-app’ an application that uses a db like SQL 2008 express? This question is from the Microsoft Virtualization Chat held on August 27th.

Answer Question   |  September 10, 2009  9:23 PM
Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL 2008, SQL Express, SQL Express 2008, V-App, Virtual Apps

how i do save picture in data base vb.net
iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

Answer Question   |  January 23, 2010  7:58 PM
Access Database Attachments, SQL Express, Visual Basic

SQL 2005 Express installation on 2008 server 64 bit
I am trying the install the SQL 2005 Express on Windows 2008 64 bit OS. I keep getting the following warning message..” Failed to find the ASP.NET Registration”. Im a newbie to this..so any help would be appreciated. thxs

Answer Question   |  August 20, 2009  7:40 AM
SQL Express, SQL Express 2005, SQL Installation, Windows Server 2008

SQL Express used for SSIS?
Can sqlexpress be used for SSIS

Answer Question   |  August 20, 2009  12:18 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS

SQL server 2005 to SQL server 2008
I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

Answer Question   |  July 16, 2009  4:35 PM
SQL Express, SQL Server 2005, SQL Server 2008, SQL Server Training

Event ID: 2803 and 17137 Question
I have recently installed SQL 2005 Express and Symantec Backup Exec for Windows 2003 SBS. I have not created any backup jobs and do not have an Active SQL DB just yet. However the following Information Events are being logged under Application Event every 5 minutes. Is this normal and is it necessary? The following [...]

Answer Question   |  June 24, 2010  4:54 AM
Backup software, SQL, SQL Express

Bundling SQL Express Edition
Is it free to Bundle the SQL Express Edition within our Product or along with our Product CD/DVD?

Answer Question   |  April 1, 2009  12:29 PM
SQL Express, SQL Server Express Edition

SQL server 2005 Expr Adv services – installing SP2
Hi folks I have a 64-bit vista ultimate PC with all SP’s applied. I have been attemting to upgrade the existing instance of SQL Server Expr to SP2, but it stops installing with an error dialog box saying: SQL BPA command line has stopped working Eventually I end up on a web page containing the [...]

Answer Question   |  October 27, 2008  9:54 PM
Authentication, Installation, SQL Express

Achieving merge replication with SQL Express 2005
I wish to achieve merge replication with multiple publisher nodes replicating to a central distributor which merges the data and publishes back out. However, I only have access to SQL Express 2005 with only one license for the full edition. Is it possible to achieve this with what I currently have?

Answer Question   |  October 2, 2008  5:17 PM
Merge replication, SQL Express, SQL Express 2005