Here is a rewrite of the script to support that.

DECLARE @DatabaseName VARCHAR(128) = 'TrainingDB'

SELECT *

FROM msdb.dbo.backupset a

LEFT OUTER JOIN msdb.dbo.restorehistory rh

ON a.backup_set_id = rh.backup_set_id

WHERE database_name = @DatabaseName

AND [type] = 'D'

AND...

What's the service account for sqlserver?

This can sometimes have an effect on the output of xp_dirtree.

congrats

Is it the ssms process or is it SQL server that keeps doing that?

32 bit or 64 bit?

does it happen when executing code or just with ssms open?

Does the same...

Gizmo

Lynn Pettis (7/11/2012)

---

You keep asking the same question. There are two system views that will help you: sys.databases and sys.master_files. Look up these views in Books Online and...

Here's a starting point for you

Select *

From sys.databases

Try something like this:

DECLARE @DatabaseName VARCHAR(128) = 'TrainingDB'

SELECT *

FROM msdb.dbo.backupset a

WHERE database_name = @DatabaseName

AND [type] = 'D'

AND server_name = @@servername

AND NOT EXISTS (SELECT *

FROM msdb.dbo.backupset a

WHERE database_name = @DatabaseName

AND fork_point_lsn...

thanks for the question.

exploding grapes

You're welcome.

CREATE TABLE #FileProp (dbid INT,FILE_ID INT, SpaceUsed DECIMAL(14,2));

GO

EXECUTE sp_msforeachdb 'USE ?; Insert Into #FileProp (dbid,FILE_ID,SpaceUsed)

SELECT database_id,file_id,FILEPROPERTY(name,''SpaceUsed'') from sys.master_files where DB_NAME(database_id) = ''?'''

SELECT DB_NAME(database_id) AS DBName,physical_name,CONVERT(DECIMAL(14,2),size)/128 AS FileSize, growth

,CONVERT(DECIMAL(14,2),max_size)/128 AS...

Please post responses to this thread:

http://www.sqlservercentral.com/Forums/Topic1327819-391-1.aspx

We do not want to get the answers fragmented.

Post the query that you decided to settle on adapting for your needs. I am assuming that you followed recommendation and actually made changes to queries to adapt rather...

Confio Ignite is an excellent tool. IMHO - best tool out there for monitoring wait stats.