SELECT a.o_id

 , a.o_tmst

 , a.from_dept

 , a.to_dept

 , b.to_dept

 from dummy a

 inner join dummy b

  on a.o_id = b.o_id

 where b.o_tmst = ( select max( o_tmst)

       from dummy c

       where c.o_tmst < a.o_tmst

     &nbsp

I thought you had to have admin rights on the box. Are you sure these people don't have rights to stop/start services?

Some other threads:

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=120949

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=111280

http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.asp

http://www.sqlservercentral.com/columnists/ckempster/mappingdatabasefileobjectsandfragmentation.asp

David, I assume you'd move it like you'd move any of the system dbs. Is this moving to a new location on the same server? Or a new server?

MS Ref:...

As mentioned above, probably you are specifying NULL for the identity. Don't do that, just ignore it like it didn't exist.

you might want to use replicaiton instead.

Use this to build the loops

declare @i int, @j-2 int

select @i = 1

while @i < 36

 begin

 if @i < 27

  select @j-2 = @i + 64

 else

  select @j-2 = @i + 48 -...

Do they get this when EM starts? Perhaps they do not have master access?

Did you change any other parameters?

Like the -d?

I'm sure you can create an unattended installation file with the setup. BOL has instructions:

search: Performing an Unattended Installation

http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en

That is interesting. Did you delete and recreate the message (in that line) to eliminate any suspiscious characters?

Check that tempdb is set to authogrow. You can extend tempdb onto another drive if that one if out of space.

Look for long running transactions and kill them, you may...

Which book?

Brian Knight's DTS book (http://www.sqlservercentral.com/columnists/sjones/prodts.asp) talks about dynamic properties a little as does Darren Green's site (http://www.sqldts.com)

I tend to use SQLMail with Exchange in most places, but there are times when I've needed to send mail. I've use the above techniques as well as ASPMail with...