Simple query

DECLARE @ColName Varchar(128)

SET @ColName = 'yourcolumntosearch'

Select t.name as TableName, c.name as ColumnName, ty.name as DataType, c.max_length

,'('+ convert(varchar,c.precision) +','+ convert(varchar,c.scale)+')' as Precision_Scale

,d.definition as DefaultConstraint

,c.collation_name

From sys.tables t

Inner Join sys.columns c

on t.object_id...

nice script lowell.

Here's a starter for you

Select * from sys.master_files

From there, you can retrieve the information you need and customize the script to your needs.

It sounds like the data file grew to meet the max restriction on growth for that file. Are you out of disk space too?

Check the connection string that you are using within the application (Access).

Jeff Moden (7/10/2012)

---

Thanks, Phil... I appreciate your time and the example.

Shifting gears a bit, I still think it strange that DBAs will allow such things to go on in SSIS...

Monkees

rhythmk (7/10/2012)

---

mayank.gauswami (7/10/2012)

---

Hi All,

Can anyone help me and show me right way to prepare for these exams.

please post a good link or book to prepare....basically i need the basic...

If you can show that there is data to support a decision, it is more likely to be well received than one based on the experience, instinct, or hunches...

I enjoyed the story, thanks.

EZ PZ

One of those subselects returns no data so it results in null. You can get around that with another isnull or a query rewrite. If you provided sample...

just use the script example I provided.

SELECT

(Select SUM (ISNULL(Amount,0)) From blah1.dbo.Paymenthistory

where Billdesc like '%Blah Blah%'

and Receivedate >= '6/30/2012 00:00:00'

and Receivedate < '6/30/2012 23:59:59')

+

(Select SUM ((ISNULL(Amount,0)) From blah2.dbo.Paymenthistory

where Billdesc like '%Blah Blah%'

and Receivedate >= '6/30/2012...

Are you able to connect through SSMS from your workstation and from the server itself?