See http://www.sql-server-performance.com/sql_server_log_shipping.asp for some more information on log-shipping including some scripts and details.

EXEC sp_dboption 'nameofdatabase', 'read only', 'FALSE'

 works but you can't run this command if you haven't fully restored...

There are some great articles on log shipping including a script on this site.  I've never used the script but its worth looking into.  I agree that replication is probably not...

EXEC sp_dboption 'nameofdatabase', 'read only', 'FALSE'

For applications that need to be shared we generally use CITRIX to deploy.  Another optionas  Yelena mentioned is Terminal Services see http://www.microsoft.com/windowsserver2003/technologies/terminalservices/default.mspx

Trying to do this via shared drives could...

Brilliant Steve.  Thanks for sharing that letter.  I've worked at companies that tried to accomplish what peoplesoft seems to be.  That is rewarding some more than other based on perormance...

There is a fair bit to security.  basically it means ensuring that your server is available only to those who need it and unavailable to anyone else.  It also includes...

I use Red-Gate's product in production.  It works great.  I tested both Litespeed and Red-Gate and found little performance difference.  In some cases Red-Gate's product was faster.  Given that I...

Just a thought. You want to reconsider why you want to restore your master db to begin with.  Restoring all your user databases and copying over all logins, then resyncing...

If there is nothing else on this machine, I would rebuild it at this point.  That is reformat the hard drive; reinstall windows and SQL Server.  This will take...

Right click on a dll; choose properties then select version tab to display the version of the dll.

The comcat.dll can be copied from the SQL Server 2000 CD.  The other...

Did you remove MSDE2000 ?

I suspect that MSDE caused problems with the DTS dlls.  You could look for the dll called Comcat.dll which should be in the WINNT/SYSTEM32 directory.  Mine...

Sara has a great point.  If what are are doing involves parameters which are going to be part of a where clause and may or may not exist check out...

I was in Phoenix last year in August.  Damn its hot!   Close by to Phoenix are lots of nifty places to see and lots to to do.  I took a...

Assuming you can connect to the database use Profiler.  see http://www.sqlservercentral.com/columnists/bkelley/auditingwithsqlprofiler.asp for help setting it up.  If its a in-house developed app, the application name may not show up but...

On the SET command the first parameter is (from BOL)

the name of the Windows domain containing the Windows user account specified in agent_username. agent_domain_name is nvarchar with no...