Thanks Jeffrey

for all your input

I am sure I will have more issues as I progress

Jim

Hi Jeffrey

that looks good

but here is what i found out

it seems that after you create your accounts and profiles, you "HAVE" to select a default one to use

and if you...

Hi Jeffery

not sure how to check that

I have tested DMail

I have run a EXEC msdb.dbo.sp_send_dbmail test

they both work fine

Thanks

Jim

Hi Jeffrey

I am running:

Microsoft SQL Server Developer Edition (64-bit)9.00.3042.00 SP2

Microsoft SQL Server Management Studio9.00.3042.00

Jim

Hi Folks

can anyone tel me what to look for if my test email works fine, but when i add a Notify Operator Task, the jobs gives me a fail message:

Message

Executed...

Thanks Mr or Mrs. 500

Hi Jacob

thanks for your input

Jim

Thanks tosscrosby

I am trying not to use "attach" amd "detach" as from what i have been reading, these are soon to be deprecated

so i am using "ALTER DATABASE" commands

it's...

So Folks

bottome line...

should the reportserver database and the reportservertempdb databases stay on the c drive where they were installed or can they be moved ?

Thanks

jim

Hi SRI

I have not got that far yet

I wanted to see the database in an offline state via sql and i do not

It is off-line in the GUI

I do not...

Hi SSCarpal Tunnel

well i am not sure what to think

i have had it off-line for over an hour and when i chk via the sql it still shows on-line

Thanks

Jim

Thanks very much for the info John

Jim

Thanks Krishna

Jim

Thanks Gail

Jim

Hi Krishna Potlakayala

no problem

have not learned how to speak "SQL Server" quite yet

when a database is created i see there are two files .mdf and .ldf

i want to move...