For MSDB storage the files get sucked into MSDB and nothing is needed in the file system unless the packages themselves use something there..

CEWII

On the SSIS server you don't see your package listed under Stored Packages|MSDB or any directory under that?

If not then I would say it isn't in MSDB. You can...

I have seen a couple installations where SSIS was separated but in general they are run together. About the only compelling reason I could think of is if you...

You can also store it in SQL Server..

CEWII

First using linked servers in a trigger is not a good idea. A better way is to call a sproc on the remote side and let it do any...

I see Gail answered while I was formulating my answer.. I agree..

CEWII

I would only break them out in cases where I need to use them seperately, for example, when a date will NEVER have a time or when we are only...

AndrewSQLDBA (1/14/2011)

---

Nope, not homework. I am a little old to be going to school. I like the ides that you gave for the design of the databases.

What I am wondering...

First thoughts, recipe header which contains the base record, contains name and other data. A recipe ingredients table related back to the recipe header. A recipe instructions table...

Unless you want them to have a SQL server local to their machine that isn't necessary. You can install the tools only from the SQL install disk. This...

This strikes me as a bad practice. Having been on both sides (Dev and admin) I find that Devs should VERY rarely be able to modify a production system...

You are welcome.

CEWII

SQL08Kid (1/14/2011)

---

I actually do log ship a few databases to our report server but for these databases that I'm having problems with I can't because they can't be read-only.

We used...

The first is used by SSIS to do a NULL test, ie: ISNULL(Field) returns true or false. The second is SQL saying that is the value is NULL then...

Have you considered Log Shipping?

I was a little concerned that there were a lot of schema changes, in a production system schema should be fairly static.. Are you doing...