i use sql server express 2005.
By mistake, there are two identical records in a table (no primary key).
When i try to delete one or to change a field, i get the error:
"the row value updated or deleted do not make the row unique or they alter

I am trying to restore database from SQL 2005 to SQL 2005 Express.
I am getitng an error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

I took over a project and the former developer installed sql 05 and is
running the sql services under 'Local System account'
should the services be running as 'SA' or no?

I have an installation ov Vs2005 with MS SQL Express and SQL Developer. I
installed now the MS SQL SP1. But this does not updated SQL Express.
Can I install now the SQL Express sp1 ? I don't want to downgrade the
developer installation.

I am doing development on two computers.
What is best way of moving databases from one box to another without
recreating users and reassigning their permissions?
Thanks

I've installed it on W2003 R2 SP2 server
But after it finishes - i can't see Server Management Studio in the menu
(I've checked the MSSQL service is started OK etc.)
I just see SQL Server Config Manager

i am looking for a way to slipstream sp2 in sql 2005 installation i wonder
if it possible?
if yes please advice how
Thanks in advanced

Is ther a way of adding a new user to database users with giving him
permissions to all SPs and UDF functions at once without going to each
specific procedure?
Thanks

I am trying to install 2005 developer on Vista. Every time I try I just get
"Error 1706. Setup cannot find the required files. Check your connections to
the network, or CD-ROM drive. For potential solutions to this problem, see
c:\Program Files\Microsoft\OFFICE11\1033\SETUP.CHM".

I have a database set to simple mode but the transaction log is constantly
growing . what can I do? I can not backup the log Because the DB is in
simple mode. I am I doing some thing wrong.?
Please help!

I'm trying to install SQL Server 2005 service pack 2 on a brand new Dell
server. The installation is not working because the authentication
screen it says "your account information could not be verified" if I
click "Test" or Next.

I have recently installed (successfully) MS SQL Server 2005 and all seems to
work great when using the 'SQL Server Management Studio'.
I also need to access the databases I creat through SQLCMD but when using
the command I am faced with the following error message:

I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65
-e4465cdff1e7&DisplayLang=en
Here is the command line that fails :
"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress

I am not able to install std edition of sql 2005 on windows server  2003
machine. At setup progress, it hangs first at "Installing Local Groups" and
than "Setting File security". I checked the logs but nothing useful.

During install of SQL 2005 DEV edition i get the following error
"SQL Server Setup was unable to add user NT SYSTEM\SYSTEM to local group
SQLServer......................................."
The options that picked during install