Yes, I am running sql server express.

Sorry GilaMonster, I by mistake didn't see your name. I have now changed the autogrowth by 100MB. There is enough size on the disk. I am still having the same...

Hi SSCChampion,

This is what I have right now.

Data...

The reason i have to create 10 indexes is all these fields are used in a web application. The user selects the fields and gets a count of records based...

I was able to send an email using Send Mail task.

Thanks to all of you guys. We were able to solve that. What we did was we exported that 2GB table to a new database, then we removed it from...

Thanks a lot Ken for your idea. I will give that a shot. Thanks!

Thanks Ken! So right now we can't just shrink the database then? Why is that Reserved so big on that table?

After running sp_helpfile on that database, this is what I got.

Data file size - 4193216 KB; maxsize - Unlimited; growth - 1024KB

Log file size - 504 KB; maxsize -...

Currently, my table is not that huge, so it probably took the same time to get the results. I can try in a larger table and let you guys know...

Thanks Chris! I just added one more parameter on the subquery (B.Album_Type_ID).

Select A.pic_id, A.Album_Type_Id,

(Select MAX(B.pic_id) From Album B Where B.pic_id < A.pic_id And B.Album_Type_Id = @Album_Type_Id) as Next_Id

From...

Thanks SSCrazy..it worked pretty great.

Thans Jack. That helped me a lot.

Hey Raj,

I added the Send Mail Task to the package. The way I have linked that to the control flow is:

Execute...

I have opened the package in Business Intelligence Studio. On the properties, i see a FailPackageOnFailure and FailParentOnFailure properties but I do not see Notification anywhere. Could you tell me...