Code looks OK to me, but its hard to say what might be happening without seeing the Package. Please attach it to the thread so we can have a look.

As...

Are you using sp_MSforeachdb by any chance? Please post the script you're using.

ALTER DATABASE tempdb MODIFY FILE changes the initial size settings but they do not take effect until you restart the service. Shrinking tempdb is risky too and is not recommended...

I...

Another option for automating index and stats maintenance that I highly recommend:

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

:exclamation: Note, this thread is almost 3 years old. :exclamation:

Maybe start a new thread next time?

http://www.sqlservercentral.com/Forums/Forum1526-1.aspx

-----

Hello,

I have read that a SQL agent startup account should not be a admin on...

Looping Through and Loading Files with SSIS < while you're not going to be loading the files into a adatabase this video will show you how to configure a FeLC...

sqlfriends (5/20/2013)

---

We would like to do this in SSIS package:

1. pull a list of employeeID, with their address from a SQL server table using select query (we can use Execute...

Sifiso, Rajeev, thanks for the positive feedback!

First approach that came to mind:

1. Setup a tally table in your environment.

SET NOCOUNT ON ;

GO

-- Credit: http://www.sqlservercentral.com/articles/T-SQL/62867/

--DROP TABLE dbo.tally

--=============================================================================

-- Create and populate a tally...

dan-572483 (5/17/2013)

---

We have a group of users who need SSMS access to a group of databases on SQL Server 2008 R2. Preventing them from connecting to or reading...

KoldCoffee (5/19/2013)

---

Foundation: trust that the person posting the topic wishes to achieve a solution for *that* problem. The person does not want to examine his whole existence and the...

Sorry for the delay. The email notification that you posted more info slipped by me and got buried in my inbox.

I opened the .txt file you attached but it...

Those were two quick samples. There are tons relating to this issue, but I hear what your saying about not knowing how to ask a question when you don't know...

To be fair "easy" is subjective too. I guess i just see this one as more about knowing which config options are there as opposed to having to design an...