Yes, both are 2k5, 64bit, and clustered.

This sp is named usp and somehow got created under system sps in one instance and under the regular sps in the other. Same script.

I backed up msdb and used delete from sysdtspackages and seems to be working.

Its actually for a dts package. In order, simultaneously, it runs the backup task and on failure, it sends an email, however, i just want to add the error message...

I am having this same issue moving objects from one sql server 2005 instance to another. No answers to this?

Step Error Source: Microsoft Data Transformation Services (DTS) Package Step...

I have them set up as dbo and they still get this error. What am I missing?

Right, it's only a handful...

So if I choose to do one table quarterly for 2 years and another table monthly for 2 years. That would be a total of 32 files and filegroups....

Ok. I'm not too familiar with partitioning and here's what I have.

Table1 with millions of rows

I created the quarterly function and schema

I created 4 tables, Table1_20081stQtr on schema

Table1_20082ndQtr on schema

Table1_20083rdQtr...

I'll try this one out, thanks!

I'm not sure if it might be a version issue. is it Enterprise, Standard? Are you trying as SA?

See if this link might help.

http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/

Datbase Mail is found under the Management tab. Is that where you are looking?

Has anyone found good, step-by-step partion instructions? Preferably an example that partitions table into 3 or more???

SQL Server error logs, logged the full log on a database, however there are no error logs on sql server agent since the alert was never sent.