A concern about the application failing in such a way that it would require significant time to re-start.

Not 100% sure that is going to be an issue.

Regardless as we...

I want the query to fail and the connection to remain

It is a currently running query. So what I want to do is basically do send of a raiserror to an existing connection...

Until you need to roll something back or need to recover to a point in time..

T-log data is just as important in many was as 'data' data...

You have the lecture on why not to autogrow so I will skip that.

With a 40 MB autogrow causing a timeout I am confident you may have the space to...

I suspect it because some data it stored in a different location.

Unless you want to see how it responds to a server failure/shutdown do it manually, you can watch it more and if there is an issue during failover it can...

Seems logical.

Another thought, do you have a lot of databases expanded out in Object explorer?

How many traces?

Also did you do a sp_who2?

With this table

==

d modulename processstamp

1 module1 4/13/2010 10:16:00 AM

2 module2 4/13/2010 10:26:00 AM

==

run a job like this

declare @newest datetime

select @newest = max(processstamp) from myTable <-- your table name...

Option B is to wrap everything in a big transaction that holds a table exclusive lock and create a 'new' table with the indexes and data types you want as...

Ok,

How static is the old data.

Well this is a bit of a logical guess, but the I/O messages you are getting indicate the server is really busy with I/O or has bigger I/O problems.

Regardless,

I...

Don't think so. To do most things with tempdb (like move it) you need to stop and start SQL Server since tempdb gets created at startup.

Also you will need to move any accounts over. You should be able to find a script that will reverse SQL passwords from 6.5