SQL Server Express Questions and Answers

Recent IT Questions

1 - 14 of 14
<<PREVIOUS 1 NEXT>>

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...

asked by SQL Server Ask the Experts

  2445 pts.

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...

View Answer   |  Jun 27 2009  5:40 AM GMT
SQL Server 2005, SQL Server Express, SQL Express 2005
asked by LeninKAF

  5 pts.

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 to a...

asked by Spionred

  35 pts.

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....

asked by Navegante212

  25 pts.

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 is considerably less open, I can’t...

View Answer   |  Dec 22 2008  3:18 PM GMT
Windows Server 2003, Mapped drives, SQL Server Express
asked by SQL Server Ask the Experts

  2445 pts.

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?

asked by SQL Server Ask the Experts

  2445 pts.

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?

View Answer   |  Oct 30 2008  4:51 PM GMT
SQL Server 2000, SQL Server 2005, SQL Server Express
asked by Pdeevi

  5 pts.

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   |  Oct 3 2008  3:46 PM GMT
Visual Basic, SQL Server 2005, VB 2005
asked by Dhanson

  20 pts.

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...

View Answer   |  Sep 23 2008  7:03 AM GMT
SQL Database, SQL Server Express, SQL Server database
asked by Chukbillo

  20 pts.

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.

asked by Vad

  20 pts.

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 was...

View Answer   |  Jul 8 2008  3:45 PM GMT
Microsoft Access, SQL Server 2005, Access 2003
asked by SQL Server Ask the Experts

  2445 pts.

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#.

View Answer   |  Jun 27 2008  4:55 AM GMT
SQL Server 2005, C#, SQL Server Express
asked by Aras

  10 pts.

dtexec scripts just deleting data

since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the import\export 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...

View Answer   |  Jun 13 2008  10:14 PM GMT
DTS, SQL Server Express, DTEXEC
asked by John t

  5 pts.

Home Network Configuration SQL Express 2005

Hello, I am pretty new to Sql. I had setup a SQL Express 2005 Advanced on a computer w/ xp on it before and had no problems. I recently purchased a installed a new computer (the other one died) w/ Windows Vista. As before, I downloaded and configured Sql Express per instructions for the software...

View Answer   |  May 12 2008  11:16 AM GMT
Network connectivity, SQL Server 2005, SQL Server Express
asked by Ddog0629

  5 pts.

1 - 14 of 14
<<PREVIOUS 1 NEXT>>