Is it nonclustered index on a heap (= table without a clustered index)?

Is it a very small table, with only few pages?

What is the fillfactor?

Shailesh,

You don't have to uninstall or install anything....

Set the database owner using sp_changedbowner

For example:

use DatabaseName

go

sp_changedbowner 'sa'

go

After that you will be able to access the database properties.

Could you post the complete message?

Also check ...\Setup bootstrap\LOG\Summary.txt

It is recommended NOT to install SQL Server on a Domain Controller for security and performance reasons.

A simple example:

SELECT Column1 FROM Table1 WHERE Colmn2 = @Value

CREATE NONCLUSTERED INDEX ixTable1

ON Table1 (Column2)

INCLUDE (Column1)

DELETE FROM Country

WHERE Id NOT IN (SELECT ID FROM Table1)

AND CountryName NOT IN (SELECT CountyName FROM Table2)

AND ....Table5)

Try somethinig like this:

SELECT EmpName, count(EmpName)

FROM tblEmp

GROUP BY EmpName

HAVING count(EmpName) >= 2

Try something like this:

declare @vstrDate as char(10)

select @vstrDate...

select * from sys.objects

where type = 'U' or type = 'P'

and modify_date between '2008-12-01' and '2008-12-11'

Set the AutoClose property to False.

We'll be downloading and testing SP2 on test machine before trying it on PROD server.

I am not a DBA and dont know much about what issues we could face...

How can format the email to be more appealing? currently it is just standard text.

i.e. How could I add:

- font to selected sections?

- Maybe images (A banner at the...

It...

select * from master..syslogins

Run the...