SQL Server Express does not have the Agent service or notification services. You basically get the database engine.

http://msdn2.microsoft.com/en-us/library/ms365248.aspx

I pulled these scripts from the Microsoft 70-431 training kit:

This script allows you to view the fragmentation

DECLARE @dbname VARCHAR(20)

SET @dbname = 'AdventureWorks'

SELECT object_name(dt.object_id),si.name,

dt.avg_fragmentation_in_percent, dt.avg_page_space_used_in_percent

FROM

(SELECT object_id, index_id, avg_fragmentation_in_percent, avg_page_space_used_in_percent

FROM sys.dm_db_index_physical_stats...

Rebuild your index according to how much the are fragmented. You can do this by using the new dynamic management views to determine what level they are fragmented. ...

Phillip,

1.

Rebuilding/reorganizing indexs everday is not usually required. Index rebuilding really is really benificial when the database has moderate to heavy fragmentation. When you rebuild the indexes there is...

Is SQL 2000 installed on server2? This message occurs when a 2005 database is restored to a SQL 2000 instance. You may be logging into a 2000...

This creates the table with the keys and indexs etc.

Right click on the database --> tasks --> export...

Yes, you have everything correct. I would backup everything in the sharepoint instance, just to be safe. You can at this point restore everything back to the way...

This should do the trick.

select *

from @tb e

where e.date_e = (select max(date_e) from @tb a where e.id = a.id)

order by e.id

Sharepoint does not require embeded version. If you want to install sharepoint on standard version of sql 2005, you have to backup the sharepoint database, uninstall everything, reinstall SQL...

You cant connect to the embeded version in a traditional way because the way it functions. Try connecting to the instance using the named pipe, as the server...

You cant connect to embeded editon via SSMS. There is no other instance on the server. So you will have to install an instance of SQL server. This...

yeah right click on the database --> tasks --> import data. you are correct this will execute as a ssis package, but it does show problem columns. Once...

Yeah the default is 1433. You did say the browser service was running, right? Is this a default instance? If yes, the instance name is MSSQLSERVER. ...

This is definetly the problem. query the msdb..BACKUPSET folder and see the last place the file was backup.

Then see if you can get to it. You may have...

You have a few options here:

1: you can create a SSIS package that dumps all bad data into a file then you can fix the data

2. import the data via...