hardware guys fixed the hardware problem. I still have databases kicking errors on a dbcc checkdb inconsistency errors.

is a reboot in order or should I try and repair the...

I didn't know that xp_smtp_sendmail was a thrid party add-on.

I've always used a fat outlook client.. oh well.. live and learn.

I had to copy a DLL and run...

for anyone interested. I did a full set of system backups and then scripted out my publication.

reinstalled on a new server. started sql server in single user...

thank for all your help! !!!

as I said in my original post - this was our annual DR test. With replication paused, they tested against old...

Thank you both very much

Thanks. Should I DISABLE those distribution jobs (there are two) or just disable the schedule for both?

Thanks!

select *

from sys.fulltext_catalogs

returns NO results. Does that mean that the catalogs have not been built yet because there is no data in the tables? ...

Thank you!! and by the way. I successfully moved my master and resouce databases and I then moved ALL the databases on the second box that I...

Thank you everyone who responded for all your help!!!

I force-started sql server and reran my alter database statements WITH the filenames (DUH!!!!!)

and I was able to start SQL...

That's an awesome idea!!! I started SQL Server from a command prompt net start mssql$aml /f /t3608

I then opened a new query window and reran my statements:

ALTER...

Thank you so much!!!!!!!!!!!!!! I really did mess up!!!!!!

Do you think it would be easier just to re-install? or will that make a bigger mess?

I'm...

I tried moving the files back to their original locationbut I get the same error starting the service.. is there a way to start a session and rerun the code...

You're right!!!how dumb of me.. I didn't specify the actual filenames!!

any idea how I can fix this?

How dumb of me... I didn't specify the filenames in the Alter database statements!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! any ideas?

I thought I did it correctly...

I put the .MDF files for Model and MSDB on E:

the .LDF files for Model and MSDB on F:

and the...