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...

One of the suggestions is, defragment the indexes in publisher as well...

No. There is no differece in access from .NET code for 2000 and 2005.

However, there are...

im using an sql accoun "sa"quote]

1) Share the folder to which backups are copied.

2) SQL Server Agent service account should be a domain account, not local account.

3) Grant...

Create a Windows scheduled task.