I have a setup package that I built with VS 2005. I selected three
prerequisites in the package, .Net Framework version 2.0, MSI Installer
version 3.1, and Sql Server 2005 Express Edition.
I was wondering if I can specify the SECURITYMODE and

How is it possible to create a maintenance plan in SSMS when managing a
SQL2000 server?   The "Maintenance Plans" option does not appear under
management.
Thanks

We have a aerial photo database that has grown to 1TB in size.  The
backup file has out grown the space available.  The hardware folks are
adding a new LUN but it is less than 1TB in size.  But there is
additional space on another LUN.  Is there a way to write the backup

TITLE: Connect to Server
------------------------------
Cannot connect to( machine instance :)ETHANHUNT245.
------------------------------

I have a SQL2005 database that works fine; however when I attempt to view
Database Diagrams I get an error dialog that says:
 "Database diagram support objects cannot be installed because this
database does not have a valid owner.  To continue, first use the Files page

I am attempting to run a 2 computer upgrade from SQL Server 6.5 to SQL
Server 2000 over a workgroup LAN.  When I run the Server 2000 Upgrade
Wizard, I get the following error message:
"Unable to connect to the Export server.  Please verify that you are an NT

I have tried few times to install the SQL-Server on my machine. Everytime I
get a message indicating that I have some presvious beta software or CTP
version of the server installed. I have carefully scanned the installed
software in the control pannel list and see no indication ...

I have SQL Server 2000 installed on a Windows 2003 DC (not the PDC).  I'd
like to demote this server to a member server and then have it join another
domain.  What SQL Server issues will I run into?  I inherited this server
through the purchase of another organization.  We want ...

I am trying to install SQL Server 2005 Standard on Vista RTM. After providing
all the details, the setup stops with a error message saying that the
selected features are not valid with this version of SQL Server.
I also get a warning saying that IIS is not installed or detected ...

During SQL Server 2005 Installation I would like to change the path for .mdf
on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
Can anybody guide me how we can do it?
Thanks in advance,

I have a payroll application that runs against a SQL 2000 database.  When
this application I see a lot of Lock Timeouts / sec and the payroll runs
fairly slowly.  When I look at the Task Manager on the db server, it appears
that only 1 of the 8 processors is doing anything?  I ...

My version SQLSever 2000 has expired. How can I upgrade this without losing
my data. Our application will not work with 2005.

When installing .NET Framework x64 2.0 on a 2003 x64 either packed with SQL
2005 x64 installation or by separat downloading, it installs on C: but also
files on the largest partion available. Im my case the S: partition which
are on the SAN for the database files.

I made an initial install of SQL Server 2005 Express edition on my desktop
and now need to add additional components. The original install file bombs
with an error stating you need to use "Add/Remove Programs" to install
additional components.

I am running sql server standard 2005.
after developing a solution, i have decided to change the name of the
server to something different.  everything appears to work at the ssms
and on each client.