rbarryoung - if you dont mind please share when the dependancy tables are getting updated, or the process for that.

Any help will be appreciated. If there are no answers from sqlservercentral, God knows where I will get an answer from 🙁

Congratulations Kathy and Jacob. Way to go! - RAJAN JOHN

Marios - The link you are mentioning says about buffer cache hit ratio. I know buffer cache hit ratio and plan cache hit ratio. I am looking for references...

use windows perfmon and monitor thes counters - if you want buffer cache hit ratio, go to SQL Server: Buffer Manager\Buffer Cache Hit Ratio, if you want to know the...

none seem to have much idea on this. can someone throw some light even though not a complete answer?

No, we cannot.

see if this can help u

/*

SCRIPT TO FIND THE OBJECT LEVEL PERMISSIONS PROVIDED TO SPECIFIC LOGINS.

** THIS DOES NOT INCLUDE THE "ROLE BASED" PERMISSIONS SUCH AS PROVIDING "db_datareader" ROLE FOR...

are u able to take the backup using the same script via ssms query?

change the sqlserveragent service login to a windows login which has access to the target. the LOCALSYSTEM account cannot access a different machine. you probably are using a windows auth...

Assuming this is SQL2k5, just go to the default log folder and open the latest trace file in Profiler. It will show you the logs.

you can use trace 3607; it should skip the recovery process. Hope you have the backups in place:)

WITH NOLOCK is equivalent to READ_UNCOMMITTED. READ COMMITTED with ROW VERSION (or otherwise READ_COMMITTED_SNAPSHOT) allows the data to be read from the earlier versions of rows stored in the tempdb...

perfmon doesnt have a counter to check the "used space" for data files. It is there for log files only.

I have used two methods. one - call sp_spaceused or use the builtin "SpaceAvailableInMB" method in sql dmo "DBFile" object. Call the dmo script from a recurring schedule.