try to set the size of the database manually i-e CurrentSize * 2 size

Following is the code to do it.

ALTER DATABASE DatabaseName

MODIFY FILE

(NAME = logical_file_name,

...

can you share the error you are getting. you can also check if this helps

http://support.microsoft.com/kb/2000474

how much empty space u have ?

select [Funding] [Fundings],

[Original] AS [Originals],

[FinanceYear],

[SumofAllCol] = isnull(SUM([Previous_Year]-[Current_Year]),0)

+ isnull(SUM([CurrentYear]/4),0)

+ isnull(SUM([Variance] * 0.75),0)

+ isnull(SUM([Previous_Year]+[Current_Year]),0)

from Finance

GROUP BY [Original], [FinanceYear]

like this ?

+1000 🙂

try this http://www.mssqltips.com/sqlservertip/1084/dynamic-flat-file-connections-in-sql-server-integration-services/

on using sp_spaceused i am getting the unallocated space as -970 MB

Why it is minus?

GO

SP_Spaceused

GO

database_name database_size unallocated space ...

Normally you'd have to define each sub report in the main report and then set visibility. you can do it Like this:

1. A main report with a tablix containing a...

glad to help you 🙂

i think system is gone back to its last restoring point. If you have a system restore point that was created 5 months ago and you restore to that point...

Change this from

with (Id int, ApprovalId int)

To

with (id int, ApprovalId int)

its case sensitive 😉

execution plan will be same in a procedure as well.

how much space you have on your disk where this db is located?

did you find any difference in execution query plan after this change ?

SQL_Kills (3/11/2014)

---

How would I know if the package is using a configuration? Where would I need to check to find this out and can I still amend the package to...