Returns

database_nameBackupDateMinutesForBackupGB_backup_sizeseqFirstseqLast

AdventureWorks2011-09-13 00:00:00.0000.20.171 1 1

Thanks

Ja

It's getting a bit above my head.

Need to polish up my T-SQL skills.

I used this part

CREATE TABLE #dbs

(

DBNAME sysname

, DBID INT

, [Total Size in MB] INT

, [Available Space In MB] INT

, DriveLetter CHAR(1)

)

INSERT INTO

#dbs

...

Hi Perry

Thanks again for all your help re the above.

I started a new thread at http://www.sqlservercentral.com/Forums/Topic1195591-1549-1.aspx

My question was

Hi Guys

Win2008/SQL 2008

What is the process of adding a previously evicted node...

Thanks a lot

Won't work for as most of my databases consist of multiple datafiles across seperate drives.

Thanks

Derek

Ninja's_RGR'us (10/24/2011)

---

Something overly complicated that shows how to use both foreach db & tables...

SET STATISTICS IO, TIME OFF

SET NOCOUNT ON

SET IMPLICIT_TRANSACTIONS ON

GO

USE [master]

GO

IF OBJECT_ID('dbo.spaceused', 'U') IS NULL

BEGIN

CREATE TABLE dbo.spaceused (

DbName...

Thanks

muthukkumaran Kaliyamoorthy (10/21/2011)

---

derekr 43208 (10/21/2011)

---

Hi Guys

I cannot find a conclusive answer to this

Does changing the recovery model from Full to Bulk_logged really reduce the size of the transaction logs when...

Thanks

Cool

Thanks

Have you had a run at the Denali CTP?

Isn't Denali now termed as "SQL 12"??

:w00t:

Any news on Denali's release?

Didnt have time to check the blog

Any issues with Sp3?

You probably gonna wanna check on a MySQL forum

Disable the alert job and you wont get the message anymore

Easiest Way.