May you don't have the permission to that particular database.

Check in user and permissions.

I guess quest software have some toddler beta free tool?

Check it out

No one have any Idea .....

I appreciate your answers.

Please check the execution plan while running on both servers gives you mpre detail information.

Even though every thing is right it me be waiting on resource or lock.

Check for it...

use data collection under management

easy and clear output with reports.

profiler is always a headache for me from my exp.

http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/

CREATE VIEW Transactions

AS

SELECT A.idnum,

A.trndate,

A.C.amount * -1 as amount,

...

http://www.mssqltips.com/tip.asp?tip=1708

http://www.mssqltips.com/tip.asp?tip=1165

Good Articles

what you are trying to do from it?

SELECT

a.file_id,

LOGICAL_NAME = a.name,

PHYSICAL_FILENAME = a.physical_name,

FILEGROUP_NAME = b.name,

FILE_SIZE_GB = CONVERT(DECIMAL(12,2),ROUND(a.size/(128.000*1024),2)),

SPACE_USED_GB = CONVERT(DECIMAL(12,2),ROUND(FILEPROPERTY(a.name,'SpaceUsed')/(128.000*1024),2)),

FREE_SPACE_GB = CONVERT(DECIMAL(12,2),ROUND((a.size-FILEPROPERTY(a.name,'SpaceUsed'))/(128.000*1024),2))

FROM sys.database_files a LEFT OUTER JOIN sys.data_spaces b

ON a.data_space_id = b.data_space_id

Try this one works for me SQL 2008...

Here is the Script make sure the code is working on test server

It Rebuilds or Reorgs based on the level of fragmentation.

--Description : This script reorganizes and rebuilds the...

Hey Guys thanks fo rthe replies but I have one question regarding this

My server min memory and max memory

is set to min---'0'

...

Check the fragmentation level and rebuild indexes based on fragmentation.

setup job like that.

so it logs only that much .

how is log backup do you have for every 15 mins...

ALTER DATABASE Adventureworks SET SINGLE_USER WITH rollback immediate;

go

ALTER DATABASE Adventureworks COLLATE SQL_Latin1_General_CP1_CI_AS;

GO

ALTER DATABASE Adventureworks SET MULTI_USER;

GO

I guess this is what you want .

I n database roles add user and give him db_ddladmin.

yes, true set the maxdop to 1 will decrease the utilization of cpu usage.

I did it..