did you start up the replication monitor

i have used transactional replication for reporting

Make sure you set all the report users to read only so they dont change it

is this for all users or just a handfull

It is possible that a handful of users may have different SID so it is conflicting.

which can be fixed with sp_change_users_login 'report'

there are lots of reasons to setup partioning

And if there is a reasonable chance the database is going to grow as they tend to do. Better to do it...

i usually make the destination folder for the log shipping logs

in a dr location so in case you lose connection they are there

did you check to see if...

you didnt say what you are linking to

I have had queries lock up waiting for the remote server to finish

if you kill them on the local server it locks up...

i have this problem almost every day

since everytime sql looses connection with the mail server (we have a very flaky old mail server)

xp_sendmail get hosed upgrade to 2005 makes this...

did you login using the outlook user name that sql is using to see that mail is working on the server

did you xp_stopmail and xp_startmail

have you stopped and started sql...

actually most of my databases are still in sql2000 mode

still i thouhgt in the past it flat wouldnt let you change from enterprise to standard without a rebuild

around my office there is a saying

Just because you can put it into one query doesnt me you should

I would break that up:w00t:

did you ping it since across domains someone may have shut you off

in order to fix my problem i had to restore all the databases to another server then copy them back to the d drive

I am sure that isnt the...

Overall summary:

Final result: Failed: see details below

Exit code (Decimal):...

trying not to sound stupid but that is the question

how do i restore the master.dbf

repair installation center says missing master

sqlcmd restore doesnt works missing master

with the master databases missing

which...

i did search it several times and it says setup with about 15 switches none of which is database backup location

or an msdn article on using sqlcmd which only works...