Hi

Make sure you have the right install 32 bit or 64 bit , it will not upgrade the engine if you do not have the correct Bit

HI

Click start and run type : Services.msc

Scroll down to sql server (Name) what does that start with ?

Whe youi execute the query you are running it as yourself...

Hi

Dabase mail need to be configured

You can use Query after db mail configured

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'MAIL', --DB mail Profile

@recipients -- =...

HI

What is your sql service starting up as ?

You need to start up with a domain account , or put back built in admins back into sql server not recommended...

Hi

There is the store procedure xp_regread. Check the master or msdb databases for the correct name.

I'm replying from my mobile

HI

Try

Select @@servername

Hi

It all depends on the storage , are you going to present the new drives from the new storage as another drive letter ,

If so you can disable the...

Hi

Are you sure its not this

DBCC DBREINDEX ('dbo.table, '', 70)

Query below for Columns per table entered

select count (*) "Number of Columns", C.object_id,O.name from sys.columns C

inner join sys.objects O

on C.object_id = O.object_id

where O.name ='Table Name' -- Enter table name

group...

Hi

The data used is still bigger then the size you wan to shrink , increase the the shrink size

Hi

You can do a print on the count to the file

Edit the code to have a @varible to the count the PRINT it

regards

Hi

Use SMTP mail

Look for the DLL file ont he internet for SQL

regards

Hi

Backup DB and Restore DB as a different name

Use script :

Backup Database ABC to disk ='c:\abc.bak'

go

Restore Database ABCNEWNAME from Disk ='C:\abc.bak'

with move 'ABC_DATA' to 'C:\ABC_DATA.mdf'

,move 'ABC_LOG' to 'C:\ABC_LOG.LDF'

go

Be sure...

Hi

Need to load the outlook, Create profile for sending mail

Hi

You will need to check the distibution database

use distibution

go

select * from msarticles where article =''

Thanks