SQL Server Express 2008 with Advanced Services Installation
I am trying to install this program on a Windows 7 OS, and I’m having a very difficult time. I have a 64-bit computer, but I’m trying to install the 32-bit version (x86) because I only have a 32-bit version at work, and I’m practicing at home what I eventually want to do at work [...]
Answer Question
| October 5, 2010 3:12 PM
SQL Server, SQL Server 2008, SQL Server Express, Windows 7, windows 7 32 bit
I am trying to install this program on a Windows 7 OS, and I’m having a very difficult time. I have a 64-bit computer, but I’m trying to install the 32-bit version (x86) because I only have a 32-bit version at work, and I’m practicing at home what I eventually want to do at work [...]
Answer Question
| October 5, 2010 3:12 PM
SQL Server, SQL Server 2008, SQL Server Express, Windows 7, windows 7 32 bit
SQL Server Express 2008 w/Tools vs. Advanced
Hi, I installed SQL Server Express 2008 w/Tools on my Windows 7 OS. I just found out that if I want to download the AdventureWorks database .msi from codeplex, I need SQL Server Express 2008 w/Advanced Services. Do I need to uninstall the SQL Server Express 2008 w/Tools and install SQL Server Express 2008 w/Advanced [...]
Answer Question
| October 4, 2010 3:18 PM
.MSI files, AdventureWorks, SQL Server 2008, SQL Server 2008 administration, SQL Server Express, Windows 7
Hi, I installed SQL Server Express 2008 w/Tools on my Windows 7 OS. I just found out that if I want to download the AdventureWorks database .msi from codeplex, I need SQL Server Express 2008 w/Advanced Services. Do I need to uninstall the SQL Server Express 2008 w/Tools and install SQL Server Express 2008 w/Advanced [...]
Answer Question
| October 4, 2010 3:18 PM
.MSI files, AdventureWorks, SQL Server 2008, SQL Server 2008 administration, SQL Server Express, Windows 7
SQL Server 2005 Express
Hi, Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation? I know it is probably a good idea to atleast change the autogrowth setting from 1MB but what about [...]
Answer Question
| October 2, 2010 6:29 AM
SQL 2005, SQL Jobs, SQL Server 2005, SQL Server 2005 Express, SQL Server Express
Hi, Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation? I know it is probably a good idea to atleast change the autogrowth setting from 1MB but what about [...]
Answer Question
| October 2, 2010 6:29 AM
SQL 2005, SQL Jobs, SQL Server 2005, SQL Server 2005 Express, SQL Server Express
Trying to Design a Split Database Access 2007/SQL Server Express
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]
Answer Question
| September 30, 2010 5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I’ve been researching this for awhile, and [...]
Answer Question
| September 30, 2010 5:07 PM
Access 2007, Database frontend, SQL Server, SQL Server Express, VB .NET, Visual Basic .NET
Spatial query optimizing
I have a development machine and a production machine with identical databases, but I’m getting huge differences in execution plans when running a spatial query. First, my development machine: It’s SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production machine: SQL Server with Reporting Services running on Windows [...]
Answer Question
| June 2, 2010 11:32 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data
I have a development machine and a production machine with identical databases, but I’m getting huge differences in execution plans when running a spatial query. First, my development machine: It’s SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production machine: SQL Server with Reporting Services running on Windows [...]
Answer Question
| June 2, 2010 11:32 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data
Merge synchronization using only Sql Server Express 2005
I’m developing a database application using VB.net. I would like to use SQL Server Express for the database so that my customers won’t have to purchase additional software along with the cost of my software. One of my requirements is that the application can use merge synchronization. Will merge synchronization work using RMO or some [...]
Answer Question
| May 4, 2010 8:49 PM
RMO, SQL Server Express, SQL Server Express 2005, SQL Server replication, SQL Server synchronization
I’m developing a database application using VB.net. I would like to use SQL Server Express for the database so that my customers won’t have to purchase additional software along with the cost of my software. One of my requirements is that the application can use merge synchronization. Will merge synchronization work using RMO or some [...]
Answer Question
| May 4, 2010 8:49 PM
RMO, SQL Server Express, SQL Server Express 2005, SQL Server replication, SQL Server synchronization
sql server express 2005 cannot see drive on my server (drive q)
I have installed sql server express on my local computer and now I would like to install it on the server (q). When I go to install it, it is not seeing the q drive. What could be causing this?
Answer Question
| December 9, 2009 4:50 PM
SQL Server 2005, SQL Server Express, SQL Server Express 2005
I have installed sql server express on my local computer and now I would like to install it on the server (q). When I go to install it, it is not seeing the q drive. What could be causing this?
Answer Question
| December 9, 2009 4:50 PM
SQL Server 2005, SQL Server Express, SQL Server Express 2005
Issues rebuilding system database on SQL Server Express 2005
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the backup). So now [...]
Answer Question
| July 7, 2009 2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, SQL Server Express 2005
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the backup). So now [...]
Answer Question
| July 7, 2009 2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, SQL Server Express 2005
Which version of SQL will work best?
We have a small but critical application that is accessed by about 30 – 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC [...]
Answer Question
| June 29, 2009 5:40 AM
SQL 2005, SQL Express 2005, SQL Server 2005, SQL Server Express
We have a small but critical application that is accessed by about 30 – 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC [...]
Answer Question
| June 29, 2009 5:40 AM
SQL 2005, SQL Express 2005, SQL Server 2005, SQL Server Express
Output errors from SQL Server stored procedure
I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details [...]
Answer Question
| April 26, 2009 1:28 AM
SQL, SQL error handling, SQL Server Express, SQL Server stored procedures, Stored Procedures
I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details [...]
Answer Question
| April 26, 2009 1:28 AM
SQL, SQL error handling, SQL Server Express, SQL Server stored procedures, Stored Procedures
SQL SERVER EXPRESS 2005 FREEZE
I have a server machine running Windows Server 2003 and sqlserver express 2005 for a client-server application. All clients machines access the server thru a router fine with good response time but if the internet conecction fails suddenly the sqlserver freeze. Any sql command takes a long delay. What could be the reason ?. What [...]
Answer Question
| April 26, 2009 1:38 PM
SQL Server 2005 Express, SQL Server errors, SQL Server Express, SQL Server Express 2005
I have a server machine running Windows Server 2003 and sqlserver express 2005 for a client-server application. All clients machines access the server thru a router fine with good response time but if the internet conecction fails suddenly the sqlserver freeze. Any sql command takes a long delay. What could be the reason ?. What [...]
Answer Question
| April 26, 2009 1:38 PM
SQL Server 2005 Express, SQL Server errors, SQL Server Express, SQL Server Express 2005
Deploying SQL Server Express to host databases off a mapped drive
I am trying to deploy SQL Server Express to be able to host a database off a mapped drive. In an open lab environment, I can get it to open and run a database off a mapped shared drive on a Windows 2003 server. However, when I take it to a client and their area [...]
Answer Question
| December 31, 2008 3:18 PM
Mapped drives, SQL Server databases, SQL Server Express, Windows Server 2003
I am trying to deploy SQL Server Express to be able to host a database off a mapped drive. In an open lab environment, I can get it to open and run a database off a mapped shared drive on a Windows 2003 server. However, when I take it to a client and their area [...]
Answer Question
| December 31, 2008 3:18 PM
Mapped drives, SQL Server databases, SQL Server Express, Windows Server 2003
Reading the content of a URL into a table in SQL Server 2005 Express
I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?
Answer Question
| December 2, 2008 4:57 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server Express, SQL Server tables
I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?
Answer Question
| December 2, 2008 4:57 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server Express, SQL Server tables
Linked servers from SQL 2000 to SQL EXPRESS 2005
I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?
Answer Question
| December 15, 2008 4:51 PM
Linked servers, SQL Server 2000, SQL Server 2005, SQL Server Express
I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?
Answer Question
| December 15, 2008 4:51 PM
Linked servers, SQL Server 2000, SQL Server 2005, SQL Server Express
Connect SQL Server 2005 Express db to Visual Basic 2005 Express
I get an error “Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but “Test Connection” gives me the same error. What can I do to resolve this error?
Answer Question
| October 3, 2008 3:46 PM
SQL Server 2005, SQL Server database, SQL Server Express, VB 2005, Visual Basic
I get an error “Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled’ to generate user instances. I run the store procedure on SQL Server and it looks like it worked, but “Test Connection” gives me the same error. What can I do to resolve this error?
Answer Question
| October 3, 2008 3:46 PM
SQL Server 2005, SQL Server database, SQL Server Express, VB 2005, Visual Basic
SQL DATABASE SERVER
Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in my PC but [...]
Answer Question
| September 23, 2008 7:03 AM
SQL Database, SQL Server 9.x, SQL Server database, SQL Server Express, SQLEXPR
Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in my PC but [...]
Answer Question
| September 23, 2008 7:03 AM
SQL Database, SQL Server 9.x, SQL Server database, SQL Server Express, SQLEXPR
sql server 2005 slow
Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.
Answer Question
| August 21, 2008 4:02 PM
SQL Server 2005, SQL Server errors, SQL Server Express, SQL Server performance
Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.
Answer Question
| August 21, 2008 4:02 PM
SQL Server 2005, SQL Server errors, SQL Server Express, SQL Server performance
Refusal to recognize SQL Server 2005 Express on a client PC
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that [...]
Answer Question
| July 8, 2008 3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that [...]
Answer Question
| July 8, 2008 3:45 PM
Access 2003, Microsoft Access, SQL Server 2005, SQL Server Express
Retrieving data from two tables in SQL Server 2005 Expree Edition using C#
how to Retrieve data from two tables in SQL Server 2005 Expree Edition using C#.
Answer Question
| June 30, 2008 4:55 AM
C#, SQL Server 2005, SQL Server Express
how to Retrieve data from two tables in SQL Server 2005 Expree Edition using C#.
Answer Question
| June 30, 2008 4:55 AM
C#, SQL Server 2005, SQL Server Express
dtexec scripts just deleting data
since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the importexport wizard are simply deleting all data in my target tables (when run via. dtexec), Yet they work ok from the wizard, and worked ok a few weeks ago. I don’t understand what this can be caused [...]
Answer Question
| September 20, 2008 10:14 PM
DTEXEC, DTS, SQL Server Express, SQL Server Express Manager
since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the importexport wizard are simply deleting all data in my target tables (when run via. dtexec), Yet they work ok from the wizard, and worked ok a few weeks ago. I don’t understand what this can be caused [...]
Answer Question
| September 20, 2008 10:14 PM
DTEXEC, DTS, SQL Server Express, SQL Server Express Manager
