it actually depends on your environment

Currently in my environment, i have network admins that handle all of that.

But if you dont have network admins, then basic knowledge is a must

it wasnt select all that work

only option 2 is correct

then i guess i dont know what you are looking for

but sql2005 developers edition from ms is like 40 bucks

has ssrs,ssms,ssis, ssas,ssds everthing to practice at home

you can get the developers version for 40 bucks i think

and it gives you everthing enterprise has

yes it works for 32 bit but on 64 bit it gives you an error message saying it isnt supported

select blockedusers=count(*) from master.dbo.sysprocesses where blocked <> 0

\c$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

if the directories are still there go into the log directory and open a log

in the top of the log is will have the name of computer

one of the check boxes on dettach box is for drop connections

If you check that is should allow you to dettach

in microsofts infinite wisdom they decided that log shipping using

transaction logs for sql 2005 would not support sql 2000 database

(this is kind of there way of forcing everybody up...

you would change the location of master.ldf by changing the startup parameters, bringing down the instance

master.ldf files should be created in the new directory

much more information needed

like what is the batch doing

It could be that your using up all your memory

and when you reboot it clears the memory

or tempdb space

MS changed something with linked servers in sql 2005 that caused several performance hits that didnt exist in 2000. I have several queries that use to take seconds across...

well i dont think it matters if they are in the same directory

but if you are a sql rookie i would leave them in the directory they were installed...

install sp2 if you can

they added alot better error messages for debugging database mail

i have had sql profiler put the final nail in the coffin of a poorly performing server. I was on tech support call with Microsoft and they gave me...