Hi All,

Anyone can advise or having similar experience? Does Microsoft release any notes to advise customer not to revoke all the default from public?

thanks!

thanks. Exact code and error as below:

DECLARE @command varchar(1000)

SELECT @command = 'USE [?]

SET NOCOUNT ON

DECLARE @tablename VARCHAR (128)

DECLARE @indexname VARCHAR (128)

DECLARE @execstr VARCHAR (255)

DECLARE @objectid INT

DECLARE @indexid INT

DECLARE...

Apology guys. I'm using dbcc as i'm running it against my 2000 db. sorry to post it in the wrong section. anyone else has a better idea or script of...

Hi SQLRNNR,

I think it's due to syntax issue like '. Can't seems to make it work. Anyway that u can help with taking a look?

thanks!

Hi,

Seems to be syntax error but i just can't get it right:

error:

Msg 170, Level 15, State 1, Line 9

Line 9: Incorrect syntax near 'BASE'.

Msg 170, Level 15, State 1, Line...

thanks for your help/ appreciate it!

thanks gila for the information.

kindly correct if my understanding is correct.

just an example: for eg: my cache is very small and can only cache up to 10 pages. below is...

Hi,

thanks for the information.

I'm wondering how is PLE dervived.

For eg,i have 12 GB of cache. If the PLE is 300, the whole cache will be flush off? Mean nothing will...

Hi,

I still don't quite understand on this.

==

If PLE is 300 (5 min) it essentially means that the entire data cache is getting replaced in 5 minutes.

==

Why does the whole...

Hi Gila,

thanks for ur response. Yes agreed.

But basically i wish to find out which of the db in the instance is utilizing the most memory. Anyway to do it?

thanks

Hi Kevin,

Appreciate response on this.

You may ignore what I have posted above.

The actual problem here i'm facing here is with an instance with multiple databases.

From the total server...

Hi Guys,

I still have difficulty interpreting the output after reading up the dbcc memory status relevant documents. Can anyone help me with this? Appreciate your time on this.

dbcc memory status...