Thanks everyone.:-)

Syntax...

That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?

Thanks a bunch!

Welsh Corgi (6/5/2014)

---

Jeffrey Williams 3188 (6/5/2014)

---

I think you are making it harder than it needs to be:

Select db_name(mf.database_id) As DatabaseName

, convert(int

...

Jeffrey Williams 3188 (6/5/2014)

---

Put the code I posted in a CTE - then use your calculations to convert it to MB/GB. Or, just wrap the calculation that is in...

Jeffrey Williams 3188 (6/5/2014)

---

I think you are making it harder than it needs to be:

Select db_name(mf.database_id) As DatabaseName

, convert(int

...

Thanks I'm trying t get the size in GB and store in a permanent table so capture the growth.

It should exclude the Transaction Log. (edit)

I will run it as Daily...

Or Drop and recreate.

Thanks.

You are right you can't set the Identity Property to true.

You can set the identity property to false by simply going into design mode and set the property to false.

I...

There is an Identity Property for a column it is set to...

This is an example of one of the statements that is hung.

There are all the same but selecting from a different object.

SELECT @cnt = AS400TableCount FROM OPENQUERY(LScypR40DAT, 'SELECT COUNT(*)...

DouglasH (4/24/2014)

---

Are there any DENY permissions set on the user for the other schemas?

If they try a SELECT query on one of the other schema tables (even though they can't...

Could you please expand on that?

I do not have control of the Oracle Servers but I can make suggestions...

I basically came up with a solution

Sean Lange (4/4/2014)

---

OCTom (4/4/2014)

---

This is my take on LINQ to SQL. I have found that it does not handle large data sets well. It can be slow. And, because...