Resource Governer is what you are looking for.

Thanks Gail,

CREATE DATABASE db_name ON (FILENAME = 'D:\xxxx.MDF')

FOR attach ; worked fine.

For SQL2000 we have moved all system and users datafile to new host with same drive letters and file paths without any problem.

My hope will be OK for you too.

hi,

when job is executing, is there any blocking and what is the lastwaittype for that spid?

how am i going to do that?

hi,

you may move all your systemfiles and other files to new disk with the same paths and then switch your drive letters. this will work fine.

Hi again,

there is no snapshot stuff neither on DB level nor storage.

we have datafiles on other drives as well. but the error is always about F.

still looking for an...

hi,

we have Symantec AV and excluded mdf,ldf,trn files so i guess this not related to AV.

about snapshot I am not sure i'll check it out.

Thanks.

hi,

you can definitely register SQL2000 instances in SQL2008 via SSMS and also SQL2k8 Query Analyzer to connect sql2000 databases.

open a sql2008 QA right click in QA select Connection->Change Connection and...

in SQL Server 2000 you can get logins with their passwords using "sp_help_revlogin"

and execute in SQL2008.

Hi,

SQL2008 comes with "enforce password policy" on by default. if you have users with weak passwords either you should make them strong or disable this for each user using SSMS....

should not query be like

SELECT

StartTime

FROM

TicketTransaction

WHERE

StartTime <= '12:30 PM'

AND StartTime >= '05:30 PM'

which backup device do you use to take backups.

hi,

maybe you can create an SP, to which you send parameters to execute DTS packages.

create proc call_dts @dtsname varchar(20), @servername varchar(20)

as

declare @command varchar(100)

set @command= 'DTSRun /S '+@SERVERNAME+' /E /N...

updating usage stats did change anything. still same.