Here is a query from Glenn Berry's Diagnostic DMVs[/url] that gives you the individual files sizes and the space available:

-- Individual File Sizes and space available for current database ...

domleg (4/9/2014)

---

Lowell,

I get the following error:

Msg 207, Level 16, State 1, Procedure TR_PrmMilkVisitExample1, Line 20

Invalid column name 'LacId'.

Msg 207, Level 16, State 1, Procedure TR_PrmMilkVisitExample1, Line 20

Invalid column name 'LacId'.

When...

One thing you should know about running DBCC CHECKDB is that it creates a snapshot of the database it is running checks on and runs those checks on the snapshot...

The first thing you need to do is identify if this is an INSTEAD OF trigger or an AFTER trigger. I believe that you want an INSTEAD OF trigger so...

This operator gathers all of the other streams to produce a single output. This is not good or bad, it depends :-D. This is necessary for the parallel plan, so...

Abu Dina (4/8/2014)

---

Sorry this is UK date so it's 5th October.

I'm actually trying to use this with an EXISTS operator. Basically the above is an extract from a transactions table...

I completely missed the request. I didn't see the "latest" in the post:blush:.

You could get that information from the default trace that is running on your server. You should have a trace running with the ID = 1 and it should capture...

Is the date we comparing to October 5th or May 10th?select *

from #SampleData

where Ref = 'Adjustment'

and Tran_Date < '20130511'This returns a single row if we are using May 5th.

What do you mean without success? You are getting errors? it is not finding the correct columns in the right...

Steve Jones - SSC Editor (4/7/2014)

---

Not sure he'd get 200 hits this year, but it's possible I guess. That would...

If he stays healthy Speaker could be in range.

RTM = Ready To Manufacture, SP2 = Service Pack 2

The one with SP2 has service packs 1 & 2 already in the installation bits so that you don't have to...

Have you looked into using the system tables (sys.objects and sys.columns) to generate the script for you? i.e. select from all tables that could have been updated (columns with varchar,...

So let me just do a reset here. The following code: SELECT ss.name as SchemaName, so.name as ObjectName

FROM sys.objects so

join sys.schemas ss on so.schema_id = ss.schema_id

where...