This happens when using a sql-user. Not with Windows authentication.

at "freeze" time ...

- are there backups running ?

- are rebuilds going on ?

- did you use sqlprofiler to capture the load

- how about deadlock situations (are startupparameters -T1204 and...

Open up Sql server configuration mananget.

Connect to your sqlserver-server.

rightclick your wanted sqlserver service, go to the advanced tab and check the startup propetries. The sqlerrorlogfile is specified with the -e...

...Does it pull them all over when you expand the file list?...

AFAIK it doesn't.

Only when you open them, it will pull them over .... My guess is this was...

By default, we add startuptraces for deadlockdetection at all our servers.

you can use this script to add the startup parameters.

If you also want to start the traces now, without restarting...

HTH

... BTW, developing using Read Uncommitted as default sounds pretty bold!  Not for the faint-hearted! ...

Indeed, but the same goes for coding a...

When you are experiencing the issue, run the query mentioned at the hyperlink. It will show you who is blocking who, this may get you on track.

You can run profiler...

SQL Profiler :

start \ programs \ microsoft sqlserver 2005 \ performance tools \ sql profiler

I'd start with the default presented trace.

Keep in mind this may have impact on your...

What's the actual size (mb) of the serverlogs ?

I guess it's pulling it over the network, hence the "not responding"

Just a thought at this time ....

Like with all hints, try to avoid them !

And if you...

- run sql-profiler to figure out what's going on

- find out what's blocking the server :

    http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/trans/default.mspx?mfr=true

did you try ...

CREATE PROCEDURE testUnique

AS

declare @strSQLExec nvarchar (1000)

set @strSQLExec = N'select * from NonExisting_object '

print @strSQLExec

DECLARE @myrc AS INTEGER

SET @myrc = 0

EXECUTE @myrc =sp_executesql @strSQLExec

IF @myrc <>...

how about books online ?

btw to avoid some hassel, some use smtpmail

Have a look at Gert's site : SQLDev.Net

maybe this can get you back up and running.

if it concerns only model, pubs and northwind.

(remember to keep the old mdf-ldf files)

Just copy another model-db (mdf + ldf) from another server...

Be very carefull !!

DBCC TRACEON (1807) : Allows you to...