-4
votes
1answer
6k views

Installing SQL Server 2005 Express on Windows 8 [closed]

We have an application that installs a custom instance of Microsoft SQL Server 2005 Express as part if the whole installation process. Microsoft states that SQL Server 2005 Express is not compatible ...
0
votes
1answer
120 views

Automate install of SQL Server 2005 Express Service Packs

Is it possible to perform an unnattended install of service packs (SP4 is the latest) on SQL Server 2005 Express? The only way I have found is to download the SQLEXPR32.EXE containing SP4 and run it ...
0
votes
1answer
78 views

Error Connecting to server with SQL Server Management Studio Express 2005

Problem logging in with SQL Server Management Studio Express 2005? When I try connecting to a server in SQL Server Management Studio Express 2005 with Server Name as PC-Name\MSSMLBIZ\SQLEXPRESS or ...
0
votes
2answers
2k views

SQL Server 2005 Express on Windows 7: Service does not start during installation [closed]

During SQL Server 2005 Express installation on a computer with Windows 7 Home Premium x64, the installation failed upon trying to start the instance service. No log file was created in the instance ...
0
votes
1answer
493 views

SQL Server Express 2005 SP4 Issues

After applying sp4 to sql server express 2005 and subsequent reboot, the service pack still appears as a needed update in Microsoft Updater.
0
votes
1answer
477 views

Change the logical name of sql server express 2005 database file?

In Microsoft SQL Server Management Studio Express for Sql Server Express 2005, I needed to copy a database for testing and keep it on the same server as the old database. I did the following: Right ...
1
vote
1answer
612 views

Is there a maximum number of schemas allowed in SQL Server 2005?

What is the maximum number of user schemas one can create in a single SQL Server 2005 database? Is this figure different on SQL Server Express vs SQL Server Standard? I've searched the MSDN ...
1
vote
1answer
67 views

Avoiding SQL Server 2005 tables with same names, but with different owners

What is the most likely cause of this behavor with SQL Server 2005? TEST #1: I run Management Studio Express, connect to my local database with "windows authentication" and see that I have 1 ...
1
vote
3answers
1k views

SQL Server 2005 Express: Where is the Profiler?

i'm reading on Microsoft's site that SQL Server 2005 Express Edition has Profiler: Profiler Express Local and Relational Servers only. (i'm not sure what a non-relational SQL Server is, ...
1
vote
1answer
254 views

SQL 2005 Express: How to get those performance reports?

How do get go about being able to view those performance reports on SQL Server 2005 Express Edition; you know, these things (with the charts and bar graphs): What are they called What do i have to ...
0
votes
2answers
142 views

SQL Server 2005 and SQL Server Express on the same machine?

Can we have both version installed on the same computer?
0
votes
1answer
967 views

How to DENY access for a particular database for login “sa” and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create ...
2
votes
2answers
1k views

Replication with SQL Server 2005 Express Edition and SQL Compact Edition 3.5

I need some information on SQL Server 2005 Express edition. What I want to do is have my central database servin local machine databases IE back office Cental database ...
1
vote
1answer
1k views

Cannot stop SQL Server recovering database

I wanted to physically move the files associated with a database in SQLServer 2005 Express. I backed up the database, detached the database, copied the files to a different drive, and then reattached. ...
1
vote
2answers
404 views

Which Performance Counters to use for SQL Server 2005 Express

Usage Scenario I have a SQL 2005 database running in an instance of SQL Server 2005 Express Edition. There are two different .Net applications running that constantly connect to this database and ...