...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...

..Now I have to go find out why all our upgraded master databases are set to a compatbility level of 80...

If you've upgraded, the compatibility level has not been changed....

maybe this can help you out ....

create table #PhoneCalls (CallId int not null identity(1,1) primary key, CallTime datetime not null, CallEnd Datetime not null default ('9999-12-31 00:00:00.000'), CallDuration int not...

as you will have noticed, SSIS is not cluster aware. What I mean is SSIS is not member of a cluster group, unless you install it yourself.

This means, you'll have...