Thank you for quick replys Dudes.

Any other suggessions please with link or screenshots to setup this.

Thanks in advance

Iam also facing the same issue in one of our production sql server

Any other sugessions please

...

yes ineed to do this Do you want to know about growth forecasting?

as well with regular dba task to increase the performence of the DB

monthly my...

thank you all

thanks for u r replys

we increase the RAM to another 4GB Now the total RAM size is 6 GB

my question is

Now My dbase is 6gb

2Gb Ram...

same issue is happened in our production box

Any suggessions pls

thanks in advace

replys please it is a critical issue in our production box

thanks in advance

when i execute the query it is giving huge o/p with some error

last steps of error message :

@previousTempToDate

Jan 31 2009 12:00AM

@CostingPeriodToDate

Jan 31 2009 12:00AM

TEMP TO DATE

Jan 31 2009 12:00AM

EMPLOYEE...

Any another or alternate solutions please

Hi all thanks for u r valuble replies

it is working fine, if i excute this procedure in query analyser. through scheduler it is failing.

it is tested in in test server

i...

Hi, all thanks for u r valuble replies.

IF i need to upgrade the current version

(8.00.2039SP4Personal Edition)(Microsoft SQL Server 2000 - 8.00.2039

(Intel X86) May 3...

Hi,

Please provide how to check this

How many connections are on average hitting your database?

Can you see any blocks occuring?

Have you run the MS BPA yet

Thank you very much for your replies but it is not working in sql 2000

pls provide solution to work all the versions of sql

Thanks in advance

hi all

finally i followed this below link it works for me.

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

its very good link try this

Thanks

Hi i executed the above script found error

for MDF

Server: Msg 208, Level 16, State 1, Procedure MoveAllDatabaseFile, Line 34

Invalid object name 'sys.master_files'.

Server: Msg 208, Level 16, State 1,...