Came across this SSC post

it contains this link: http://msdn.microsoft.com/en-us/library/ms191291.aspx

FYI: There is a forum section for SQL Server 2000

Instead of all the PRINT statements (and cursor) this is what I had in mind.

exec sp_MSforeachdb '

USE ?

SELECT "ALTER DATABASE"

, DB_NAME()

, "MODIFY FILE ( Name ="

, name

, ", FILENAME =...

rpalacios 19022 (10/4/2010)set nocount on

declare @dbname as varchar(80)

declare @server_name as varchar(20)

select @server_name = @@servername

declare rs_cursor CURSOR for select name from master.dbo.sysdatabases where name not in

('model','master','msdb','tempdb') and filename like 'S:\Data\Test%'

open...

You would create the script as the example shows, creating a command for each database. It would work the same way if you script out the dettach/attach process.

You can...

If you are just moving them to another drive and keeping the same folder structure using ALTER DATABASE may be less overhead. See this link.

--This is from the link...

What else is leading you to believe it is slow, other than what you saw in Task Manager?

http://msdn.microsoft.com/en-us/library/ms177596.aspx

It should show you the tables you have in your database.

Actually according to this: http://msdn.microsoft.com/en-us/library/bb522526.aspx It is used to define table-valued parameters for stored procedures.

http://msdn.microsoft.com/en-us/library/ms190203(v=SQL.90).aspx

In case you want to read on it.

Changing recovery model does not terminate any connections to the database.

Would something like this work?

select top 100 *

from dbsrvr2.queues.dbo.OUTqueue2 a (nolock)

where...

What OS are you running (32-bit/64-bit)?

Can you provide the script or link to it that you are using?

Are all the directories you have referenced in the script valid?

You might try checking also how many records are in the table holding the job history. I've seen the GUI timeout just cause there were so many records to...

You might watch the network resources on the server, if you have not already. Maybe setup...